Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

Saving records in their sort order

Last updated: before December, 1998

Sort the records as you want them, and then export (ALT-FILE-EXPORT) that database into a new .dbf file. This .dbf must contain the same files as the old .dbf. Delete the old .dbf and rename the new .dbf with the old .dbf file name. e.g. Say you have a database called PEOPLE.DBF. Sort the records and export all the fields in PEOPLE.DBF into another database called TEMP.DBF. Exit Approach. Delete PEOPLE.DBF. Rename TEMP.DBF as PEOPLE.DBF.

In short, it is much better to just save them in entry order and sort them once they are loaded...

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.