Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Appending from a table
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement