Max Row Index Count

Classic Servoy
1

What is the difference in the these two ways of getting the complete found set count;

globals.Number1 = .getMaxRowIndex();

globals.Number1 = databaseManager.getFoundSetCount();

I know the second is an expensive operation, but I have little choice the few times that users need to return more then 200 records.

Also, the mehod editor say there are syntax errors with both these.

Thanks.
Erich

2

ebrandt:
What is the difference in the these two ways of getting the complete found set count;

globals.Number1 = .getMaxRowIndex();

with controller.getMaxRecordIndex() you get the maximum number of rows in your foundset but limited to the (pre-)loaded rows. So at first you have 200 (or less if you have less rows). If you loaded above that you get the above in chunks of 200…

globals.Number1 = databaseManager.getFoundSetCount();

databaseManager.getFoundSetCount(foundset); counts all records

I know the second is an expensive operation, but I have little choice the few times that users need to return more then 200 records.

Also, the mehod editor say there are syntax errors with both these.

See my answers above. That will give you the right syntax… And, check your sample code in Servoy.

Cheers

3

Muchas Gracias