Hi!

I have a grid class which allows users to sort any column (asc or desc) by clicking on it. Internally it creates an index on the fly and handles row/table buffering etc.

All this works fine but how do I handle sorting/indexing columns in a table buffered cursor with modified rows (uncommitted changes)?

The users do not want to save the changes first but add, change data, sort on different columns, have a look at the data and then decide if they want to save the changes or not.

I would prefer not to create an index on every column in the table as there are many columns.

Sarosh