Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Updating delete record
Hi:
I use a View to update a Table. This table has an unique index.
There is a deleted record in the Table, DELETED is SET ON (so, the View doesn't have the record). The user append a record in the View and replace index field with a value X. If index field in View is the same as one deleted in the Table, then I TABLEUPDATE and VFP answer me Error 1884 "Index Uniqueness violated"("Se ha violado la unicidad del indice") cause its a repeated index
The answer is: Is possible to know, from View, that record in Table es deleted and make a RECALL-UPDATE... instead of INSERT INTO...?? or, same thing, how do I help error 1884??
Thanks
mandy
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement