Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating primary key from imported data
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00066546
Message ID:
00066549
Views:
34
>I am importing data from a text file into a VFP 5.0a table. I need to create a primary key for this table. I tried creating a new field with a default value of SYS(2015) to create a unique value. But this doesn't work -- it fails after importing the first record.
>
>Any ideas?
>
>Jeff

That's because SYS(2015) will check for unique procedure name and new record added will add nothing to the list of available procedures, right? So, change your mind and use proven approach of generating new consecutive integer ID using 'setup' table.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform