How can I get the total of records found

[Robert Iliuta]

Hallo,


I have a form with a browse and I use locator to search in the browse. How can I get the total of records found ? I use page method and the NT total will give me only the total by page ......

Thank you for any suggestions,

Regards,
Robert Iliuta

[Bruce]

Hi Robert,

It's a pretty expensive check because typically the only way to know the number of records is for the whole result set to be read.

In a subset of cases (specifically TPS where there are no key fields in the ORDER) and (I think) SQL backends, it's possible to do a Records(View) command. Do this after the call the _SetView, and before the LOOP statement in the browse.

But be aware that this gets called with _every_ page refresh (unless you specifically code against that.)

Cheers
Bruce
 

[Alberto]

Hi Robert,
Take a look at my post in the Web Server - Share Knowlage
"Adding Total Rows and Page Number to a Paged Browse"
Hope it helps,
Alberto