You must change the line
Append From CaseSQL_X into
Append From dbf('CaseSQL_X')>Yea, I thought of the NoFilter. Added to make sure but still the same.
>
>I tested an old system and it is working fine.
>
>Grid RecordSource is set to "CaseSQL"
>
>The initialize function in LOAD method of the form is:
>
>
>Select * from Event Where .F. into Cursor CaseSQL READWRITE NOFILTER
>
>Select * from Event Into Cursor CaseSQL_X NOFILTER
>
>Select CaseSQL
>ZAP
>Append From CaseSQL_X
>Use in CaseSQL_X
>
>
>Subsequent requeries use the same method of Selecting into a temp cursor (CaseSQL_X) and zapping and appending into the CaseSQL cursor.
>
>Again, first run works fine. Second instance the Grid loses its columns (now I see that even Column1 does not exist).
>
>Also, I am retracing an old system where this exact code is working on the same network.
>
>Very confused.......