Tech Tip: What order does DELETE SELECTION delete records?
PRODUCT: 4D | VERSION: 12.3 | PLATFORM: Mac & Win
Published On: February 16, 2012
The command DELETE SELECTION can be used to delete the current selection of records from a given table. DELETE SELECTION will delete records in the reverse order the selection is sorted in.
For example, if the following records were created in this order:

Then the records were sorted just before executing the command DELETE SELECTION, as shown:

The records would be deleted in reverse order, meaning "f" would be deleted first and "a" would be deleted last.
For example, if the following records were created in this order:

Then the records were sorted just before executing the command DELETE SELECTION, as shown:

The records would be deleted in reverse order, meaning "f" would be deleted first and "a" would be deleted last.