>>>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?
Edward Pikman
Independent Consultant