>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
BTW if 'blah..' doesn't cause a true cursor creation you better add 'nofilter' clause.
Cetin