Jump to content

Resort (Permanently) records


This topic is 8558 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 8558 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.