NWB Queue: Number of Records

[rupertvz]

Hi Guys,

Is there a way to display the total number of records in a NWB (displayed and not displayed) in the Heading field of the NWB?

[Bruce]

Sure, you can put anything you like in the header.
So all you need to do is;

a) create a small procedure or routine to loop through the view, counting the number of records that are in the result set. This may be a tad expensive from a time point of view, especially for TPS. For SQL you might rather construct a Prop:Sql statement to count the items in a result set.

b) use this procedure to prime a variable, or use it directly in the header.

Of course if you change the browse filter then you will need to re-calculate this number and refresh the header.

Personally I think the "cost" of calculating this number is too high.

cheers
Bruce

[rupertvz]

Thanks Bruce, the cost of counting was part of my thinking as well.

I was hoping that the NWB would keep tally of the number of records while processing the records for the queue.

I am using a TPS database.

[Bruce]

>> I was hoping that the NWB would keep tally of the number of records while processing the records for the queue.

there is no queue.

And even if there was, if it's page-loaded it just loads one page and then stops.

cheers
Bruce