NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: rupertvz on October 03, 2017, 04:28:39 AM

Title: NWB Queue: Number of Records
Post by: rupertvz on October 03, 2017, 04:28:39 AM

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?

Title: Re: NWB Queue: Number of Records
Post by: Bruce on October 03, 2017, 09:06:29 PM

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

Title: Re: NWB Queue: Number of Records
Post by: rupertvz on October 04, 2017, 02:15:35 AM

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.

Title: Re: NWB Queue: Number of Records
Post by: Bruce on October 04, 2017, 09:37:13 AM

>> 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