Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Appending to a database table with a unique primary key
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00259291
Message ID:
00259296
Vues:
16
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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform