>Naomi,
>
>Won't resetting RecordSource to an empty string 'reset' all columns? Or is this necessary if the cursor fields do not all get involved with the grid's columns?
>
>The reason why I use CursorFill instead of CursorRefresh is because I reconstruct SelectCmd which needs CursorFill to 'take effect'.
>
>Thanks
>Dennis
>
>
>>>Hi Naomi,
>>>
>>>
If you want to use this approach, then you need to reset grid's recordsource to an empty string before calling CursorFill>>>
>>>So, do you mean that instead of assigning the alias of a temp cursor with exactly the same structure as the original cursor, I assign RecordSource = "" like so..
>>>
>>>
>>>
>>>myGrid.RecordSource = ""
>>>myCA.CursorFill()
>>>myGrid.RecordSource = myCA.Alias
>>>
>>>
>>>
>>>Dennis
>>
>>Yes, that's what I mean.
>>
>>Alternatively, you can use always CA alias and use CursorRefresh instead of CursorFill if you only need to change parameter.
Andy Kramek has demonstrated that safe select is the only reliable approach in all cases. Vlad's work only worked in certain cases.