Currently our grid forms call a common onSort method when the grid headers are clicked using a mouse. However sorting only works upon loading the form at the third time. I am trying to isolate which code stops the call to onSort method.
I understand that onSort method of a form will not be called if a record of the form’s foundset is being edited. I have verified the foundset using databaseManager.hasRecordChanges method to check if the foundset has changes and it always returns false.
Are there other situations where the onSort method is not called?
Sorry, the problem was not isolated in my workspace.
The problem is when viewing stored calculations in grids. Internally when I call sort on a foundset, recalculation of stored calculations are triggered which switches the mode of the foundset to edit mode. This then stops the application thread to call the onSort method.
Currently, our autosave property is false, is there a way in Servoy where these recaclulations don’t affect the onSort method? This stops us from sorting grids.