hi,
Pls tell me How to get recourd count of query in ERP?
Pls tell me the code for the same.

Regards,
nirali

hi,
Pls tell me How to get recourd count of query in ERP?
Pls tell me the code for the same.

Regards,
nirali

Hello,

do you mean something like ?

select ......
from .......
where .........
selectdo
counter = counter + 1
display("counter")
refresh()
endselect

or :

select count(field)


Regards

As far as I know there is nothing in Baan which tells you the number of records returned by a query. So usually I use the select count() that bdittmar has recommended. One query to get the count and one query to process the records.