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:
00259296
Views:
15
APPEND BLANK does not use any memory variables, it insert a blank value to each field in the table. With SET DELETED OFF, try to see if you have a record with GroupID empty.

HTH

>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?
Previous
Reply
Map
View

Click here to load this message in the networking platform