>>
>>Try to clear grid controlsource first and set it back on the end
>>
>>

>>thisform.Grid1.ControlSource = ""
>>IF thisform.opgSortDirection.option1.Value = 1   &&Ascending
>>	SELECT * ;
>>	FROM curBrowseModal ;
>>	ORDER BY cSortSeqASC ASC ;
>>	INTO CURSOR curBrowseModalS
>>ELSE
>>	SELECT * ;
>>	FROM curBrowseModal ;
>>	ORDER BY cSortSeqDSC DESC ;
>>	INTO CURSOR curBrowseModalS
>>ENDIF
>>thisform.Grid1.ControlSource = "curBrowseModalS"
>>thisform.Grid1.Refresh()
>>

>>
>>
>>But I prefer to create and use an index and change the order on the fly
>>
>>
>>Regards,
>>Onytoo
>
>To clear the controlsource is exactly the way NOT to do it!!!!!! Read my code to see how you avoid it.

Yes, I already read your codes, but that is your "safe select" method, not mine.
If you read last line of my reply, then you should see I always use index for this purpose, so I never use "safe select" method
or emptying grid.controlsource on runtime.


Regards,
Onytoo