Sorry for the confusion, I am attempting to add record to a table in a DBC from a text file and generating a unique key in the DEFAULT property of the field. What I am getting is the DEFAULT property is not triggering and then a primary key violation with the second record append.
Any ideas???
Rex
>>Is there a way, using the DBC methods, of generating unique keys for records appended from another file? I am placing a unique key procedure in the DEFAULT method of a field, but it is not being triggered in the APPEND FROM statement.
>>
>>TIA
>>
>>Rex
>
>
> How about using INSERT INTO, in a loop? I haven't tried it but since it's adding a single record at a time your triggers should fire.
Précédent
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