>>>>>>>I have a grid displaying data of a cursor. The initialy empty cursor is created when i issue a SQLEXEC() in the Load event of my form with a whereclause that will never select any records.
>>>>>>>When i reissue my SQLEXEC(), but this time with data my grid looses its member-objects and its recordsource.
>>>>>>>This is probably because the cursor is closed and recreated when i reissue a SQLEXEC().
>>>>>>>
>>>>>>>Does anybody know the 'workaround' for this problem?
>>>>>>>
>>>>>>>Marco Beuk.
>>>>>>
>>>>>>Any time you rebuild the cursor, you should also reset grid properties: recordsource, column.controlsource(s). Another workaround is to base grid on permanent cursor and fire ZAP and APPEND FROM sqlcursor after each SQLEXEC.
>>>>>
>>>>>The funny thing, but it won't work for me.... I had the grid and I recalculated the content. I tried this trick and it won't work...
>>>>
>>>>It works Ok here. What actually doesn't work?
>>>The grid loose all column's properties (controlsource, header etc)
>>
>>You don't rebuild cursor itself, do you? I mean you do:
>>Select curGridsource
>>ZAP
>>Select curTemp
>>cDbf=dbf()
>>Select curGridsource
>>Append from &cDbf.
>>Thisform.Grid.Refresh
>>
>>This case it should work OK, because grid still have the same recordsource.
>
>Sure, I did the same thing. But it always failed... I will try it again over the weekend

I forgot to mention one more thing: curGridsource should be created by CREATE CURSOR.