Information générale
Catégorie:
Codage, syntaxe et commandes
I'd suggest scanning the outside database and insert into your table. I've used a work around before on one-time appends of turning the primary setting of my tag, appending the data, generate the key id, and then resetting the tag as primary.
>My table have a primary key: iKey
>
>This key is generated automatically by a call to NewID() in the "Default value" field.
>
>It does work well with APPEND and INSERT_SQL, but it does not work with APPEND FROM. The function NewID() is never called by APPEND FROM, leaving me with "The primary key is violated" message.
>
>Is there any work around for this problem or do I have to import the file in a temporary table (without a primary key) before importing it again in my table?
>
>TIA
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