Hi Hank,
I think the most recommended and simplest method is 'Safe Select'. You can Google for that expression.
>Hi Tamar,
>
>I have a faint memory (like all the rest <s>) of you coming up with a neat trick, back in the day, for keeping the formatting of the grid while changing the recordsource. My memory is of setting the recordsource to chr(0), but I don't remember if there were other parts. Of course this could have been pre-VFP, back in the 2.6 days.
>
>Hank
>
>>>I have a grid on a form, which services a number of files with exactly the same structure. Problem I am having is that I can't set the order programmatically. At the start the order is fine, but change the RecordSource, and try to set order, and nothing happens. I can put code in the header of a column, and physically click it, and then the order will change correctly, but if I click that header programmatically, it triggers the messagebox() I have there saying 'we are here!', but the code doesn't run. Click the header with the mouse, and it runs great. I am sure someone has battled this demon before. Thanks for your help!
>>
>>The problem is that you're changing the RecordSource. That removes all customization of the grid.
>>
>>To have code that persists when you change the RecordSource, it needs to be in the grid class, not the grid object.
>>
>>Tamar
If it's not broken, fix it until it is.
My Blog