>>thisform.MyGrid1.RecordSource = ''
>>thisform.MyGrid1.RecordSource = "search_crsr".
>>(2)
>>create the cursor in the load() of the form
>>'bind' the cursor to the grid in the form designer (RecordSource)
>>zap the cursor
>>append the new/modified data to the cursor
>
>I thought about it. As Mark said , otherwise the grid would be bound to the alias in the DE.
>The problem is that at that point I don't know the structure of the cursor, there are different SQL selects which determine both the data structure and the data.
>
>J
Well, I have always avoided setting grid.RecordSources in code. Never run into problems like that (still on vfp6sp5 too)
Can you get around by (1) creating the cursor with sql and then launching a modal form in the default datasession or (2) add the grid to the form after the sql in done (LockScreen will be useful)
Gregory