Hello all,
I apoligize if this has been asked before; I'm running in to a problem when appending to a table from a cursor.

I select from one table in to a cursor in the following manner:

SELECT blah AS blh,;
BlahCid as cid, ; && Etc etc...
BlahGubbins as Gubbins FROM ThisDb!thisTable into cursor temp

I then select a table,zap it and append to it from the cursor

SELECT SomeOtherTable
ZAP
APPEND FROM DBF("temp")

This syntax works fine if I execute the code in selected portions but does not if I run it as one whole block... I've tried using temporary tables instead of a cursor to no avail. When running the complete block of code the cursor or temp table fails to get generated and then causes an error when I try and append from it.

Any ideas or thoughts on how to get this to work?
Thanks Andre