last 200 records

Classic Servoy
1

Hi

I come from the FMP world and took some time to get use to the whole 200 records thing in Servoy. i undertand the problems it can create and as long as they can see the total foundset number its not really an issue.

My software creates sales, purchase orders etc. and a feature that is really useful is to take the user to the last record of each table. This lets them move around the latest data and easily see recent records.

is there any way to load the last 200 records and take the user to the very last record? Currently i can only get to the 200th record unless i start forcing loops to load more which i don’t really want to do.

Would appreciate any help.

2

Hi Rodney,

If you present your user with lists (like a tableview in a tabpannel), just sort your foundset in descending order at onShow of layout. This should do exactly what you need.

Enjoy it!

3

Thanks Olivier

Of course! i should have thought of that myself.

Works well in both detail or list views if you set the initial sort of the form to descending order, and go to the first record.

Thanks again.