Loading first 25 records only -- issue

Hi all,

I use scripts triggered on “onshow” of the form to load only the first 25 records of my tables (getDataSetByQuery with some SQL query).
The problem is that it looks like Servoy loads the default 200 records before “onshow” is triggered. I can see the screen flashing.

Is there any way of getting around this?

Hi Christian,

Try setting the onShowAllRecordsCmd property to -none-.
This should prevent the form from loading the default set of records.

Hope this helps.