Remember sort, reapply later

[HendersonD]

This seems like it should be simple but I cannot figure it out.

- I have a database sorted in a particular order

- I trigger a script to run a report. The script that runs the report sorts the database in a different order.

- I would like a way at the end of the report script to sort the database back into its original order.

The problem becomes the original order can be one of 14! Is there any way to remember what order a database is sorted in and then sort it in that order later? I have figured out a way in my mind to do this but the script will be long and ugly

Edited December 16, 2005 by Guest

[comment]

Why not have your reporting script open a new window, do the reporting stuff in it, then close it?