Is there a way to sort a foundset when there are editted records ? (autosave = off)
When I have a foundset with several records and one or more is changed, but not yet saved,
and try to sort it, I get an error message (triangle in LowerLeftCorner) :
Hans Nieuwenhuis:
Is there a way to sort a foundset when there are editted records ? (autosave = off)
Right now ? no.
Sorts are done on the back-end and when there are unsaved records Servoy will bark at you.
If you want it to behave differently I suggest you file a feature request.
In servoy, sorting is always done by the database, we do not interpret the sorting ourselves.
So, if there are changes that are not saved in the database yet, the sorting may give the incorrect result.
You may have changed a field that is part of your sorting, or when you have added a new record we do not know where to insert it without interpreting the sorting definition.