Case ID: 116119
So, in the past when we have wanted a form to load with an empty foundset, we have attached a method (clearMyfoundset) to the form's onLoad event. Currently in Servoy 3.5.3 it does not appear that this method works any longer. What I seem to see is the following order of events
1. Form gets loaded
2. Database Performance Manger indicates that a query runs selecting X number of records for that table
3. Records get loaded
4. onLoad method fires, foundset gets cleared.
This of course is undesirable because the entire point of having an empty foundset is to cut down on load times.
We have currently started to use databaseManager.setCreateEmptyFormFoundsets() as a solution for the time being, which is mostly working fine. However, in the end this is also an undesirable solution as well, because it forces ALL forms to have this property, which we weren't previously doing. This may be a bug, but we have noticed that sometimes we will load a record into a form before navigating to it, and then after navigating to the form, the record is gone.
My feature request is this, since it appears that Servoy performs a TOP query get the records to load into a foundset, could there be a form property, something like initialRecords, that would be the number of records Servoy should load into that form when the form is first loaded? That way, it could be the default of 200, 0 if you wanted no records, or even 1, if you wanted the foundset to not be empty, but also didn't want to load hundreds of records.