Problem: Can't move to the end of an table after performing a sort operation
After performing a sort operation on a nonOID table, such as an OLE DB table or text file, clicking the Move to the end of the Table button only moves to the end of the current record cache. It will not load all the remaining records into the table window.
Only the current record cache is being shown.
Solution or Workaround
If you wish to perform a sort operation on an nonOID table and continue to work with all the records, load all the records into the table window before sorting.