Doesn't it throw the error to your error routine when this happens? Can you trap for the error 1884 in your error routine and if the error matches, run the appropriate code? Maybe I'm not understanding correctly...
Tracy
>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
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"