>Hi Nick,
>
>the loosing settings and objects contained in a grid when changing recordsource prop. represent a problem often encountred. Is a VFP bug or a developing choice of VFP projectist ? In VFP 7 this will be persist ?
>
>Dino.
Hello Dino,
I would not consider it as a bug. It is just by design. When you close the table/cursor or rerun the SQL statement which recreates the cursor which is the RecordSource you just rip off the data source from under your grid. Setting RecordSource to "" effectively prevents loosing the settings. Note that it does not happen if you have a view as a recordsource and just REQUERY() it.
I believe it will work the same way in VFP 7.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison