I have a cursor open with table buffering to which records get appended. At one point in my form I would like to "resort" all the records in order to perform some checks before the records get saved. So, what I would like to do is a SELECT * FROM ALIAS() ORDER BY fields
Therefore re-sorting all the records that are in the uncommited table in memory. However, this SELECT statement gets the fields from the commited records in the table, not the current uncommited table in memory. What can I do?