Hi to all
I am in the process of converting my application to SQL. To satisfy my users I cannot remove some of the features in the old version. One of them includes the ability to change the record order of data been displayed.

How would one do this with SQL? I am using a SQL ID Cursor and then with related tables being queried as the record pointer moves. I thought of writing a class where the user can select the order in which he would like the data to be displayed and then store this value in the registry or even keep it in a database so that other users can use the same order. Using this string then to populate the SQL ID table on the order by clause.

Before I start with this I would like to know how other Codemine users manage this and if there is a class doing something similar as above.

Thanks
Willie
http://www.cyberprop.com