Paul,
Already tried that and it worked, I was just hoping for a more elegant solution.
Thanks
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
>
>
> The other thing I was thinking about is to do this in two steps. The first step does the APPEND FROM into a table that doesn't have the primary key set. Then take that table and INSERT it into your main table. The first step lets you use APPEND FROM to import the text file (rather than having to write your own routine). The second step gets VFP to generate your key for you.
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