>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