>PART_ID is primary index key, the orginal PART_ID(e.g. 01-001 ) record have been marked delete(), but not PACK. User add a new PART_ID, same number (01-001), and updated by tableupdate() function in our application EXE file which build up by VFP6. The error message "Uniqueness of index PART_ID is violated" displayed. Please help! What can I set unless change the type of index key.
>
>thank you
There have been several discussions here on the UT as to whether or not you should have a PK filtered on FOR !DELETED(). I'm in the camp that the record still exists, therefore, the PK should not be reused. On my web site (click the company name above) is an article that discusses PKs and how you can generate unique PKs for each record.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer