Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Generating Primary key during APPEND FROM
Message
 
To
08/06/1998 09:00:27
Rex Mahel
Realm Software, Llc
Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00105751
Message ID:
00106665
Views:
25
>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.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform