>Hi
>
>when I update the table, I get the "Failed to update - unique index violation" message by foxpro. I would like to intercept that message and show a more meaningful message. How do I do that?
>
>Or is there a way for me to quickly find out I have duplicate entries before my update.
>
>Thanx
>Gnana

How are you generating your unique keys? Are you using a view that updates a table? Do you re-use keys from deleted records?