>>>>>>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
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer