>>
>>Try to clear grid controlsource first and set it back on the end
>>
>>
>>thisform.Grid1.ControlSource = ""
>>IF thisform.opgSortDirection.option1.Value = 1
>> 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
Regards,
Ony