>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.