General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only