>>>>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)