Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Default value trigger do not fire with APPEND FROM
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
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