Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending to a database table with a unique primary key
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00259291
Message ID:
00259294
Views:
11
Jeremy,

You must have a record in the parent table with a blank groupid. Can you use insert into instead of append blank?

Rob


>I have this database containing serveral tables. One of these tables is linked >with all the other tables using a 1-m relation, via its primary key GROUPID. >When I try to append blank to the parent table, the error 'Uniqueness of index >GROUPID is violated' results. In the m.GROUPID memvar, I have a number that >was not priorly used in that table. I tried to set deleted off and see if >there were any other keys, but there were not. What should I do?
>Thanks any help.
Previous
Reply
Map
View

Click here to load this message in the networking platform