Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>I'm copying table contents from one file to another and ran into an error while copying a table with an autonumber field. It says the field is read-only (which makes sense, I guess), and won't copy the records using an append from statement. Is there a quick/standard way to get around this? I know I could do a file copy, but was hoping to just pull records as needed from the other table.
>
>As always, thanks in advance.
The trick is to eliminate the autoinc fields from the amount copied over.
To be able to use Fieldlists in xBase and SQL I build them into a variable
and makroexpand that for SQL or add as Fieldlist for xBase.
HTH
thomas
Précédent
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