Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating delete record
Message
From
31/10/2002 12:43:44
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Updating delete record
Miscellaneous
Thread ID:
00717408
Message ID:
00717408
Views:
49
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
Map
View

Click here to load this message in the networking platform