>>>Hello guys!!!!
>>>i have a 1.5 GB table in shared mode. can anybody tell me why in the H*** the first time I run "SET FILTER TO .F. " it takes 5 minutes? should i use somekind of buffering that i don't know?? would it help?
>>>
>>>thanks,
>>>ionut
>>
>>Simpliest solution (after reaing others):
>>
>>recordsource = "".
>>
>>Second is Gordon's:
>>
>>set key to -1 && if an order is available and lowest possible value is 0
>>
>>
>>Cetin
>
>
>Hello Cetin,
>
>I thought about the recordsource = '' but thought that it would blow away the grid structure/design when reset to something.
>
>e.g.
>
>recordsource = ''
>recordsource = 'myCursor'
>
>Would this not mess up the controlsources on each of the columns if they were added manually? Or would it blow away the columns altogether?
>
>I haven't tested this yet. Nor can I remember what would happen.
>
>Gordon.
It only blows away controlsource ordering (if field order is not the same as it is in grid - moved columns etc). What I do is to save and restore columnorders. Result is instant.
Cetin