ms flex grid sorting

[szlamany]

I've been working with flex grids for data entry for a couple of years now and have finally came across the need to sort.

As a user changes data in columns 1 and 2, I will be filling column 10 with a "new" sort key - so that rows move and data in columns 1 and 2 change.

It appears that all I have to do is set the .COL=10 and .SORT=1 and then set the .COL back to the column they were in previously.

It appears to be working.

I would have thought that SORT would be more of a METHOD and not a PROPERTY. If I set .SORT=1 does that only sort once? I only want to sort when the cells in column 1 and 2 change, and after I re-build the SORT KEY in COLUMN 10.

Just looking for some reassurance...

Also, should I be turning REDRAW off before the sort? Any other little tricks I should know about...

[szlamany]

First thing I just suffered through was realizing that .SORT=1 for general sort allows VB to treat the string in .TEXTMATRIX as a number...

Using 7 now for text sorting.