Resort (Permanently) records

[jwallace]

Is there a way to permanently resort all the records in a database? Would one use the Copy all records step?

[Chuck]

There are certain operations that will unsort records, such as perform a find or creating a new record. The only way to have the records sorted after you do such operations is to sort them again.

When are your records getting unsorted? Is it during a script or during a user menu chose (such as a manual find). If it's during a script, create another script to sort the records and run that sort script as the last step in your current script.

Chuck

[Vaughan]

The "unsorted" state of a database is the creation order - newest records last.

To get what you want:

1) backup your databases safely.

2) Create a clone of the databse (no records). This will become your new one.

3) In the original database, sort it the way you want.

4) Open the new empty clone db and import the records form the original into it.

5) Discard the origianl file.

They will now be in the sorted order.