Question:
I have a datawindow with a few columns. I have written a menu through which I can sort the existing data alphabetically or by value. Whenever a new row is inserted, or an existing row is changed, I want the sorting to take place automatically. I do not want to have to click on the sort button again.
How can I do this?
Answer:
In the item focus changed event, check to see whether the column that has just been changed is the column that the datawindow is sorted by. If it is, call the Sort() command.