>Hi all,
>
>I have a problem with candidate index.
>I turn table buffering on at my table with a candidate index NAME on field NAME. If I insert name into the new record by using Insert Into command and then I replace NAME field with the same value which this field already has have, I got "Index NAME is violated." message on table update.
>
>Can you help me with this (I now test whether the new value already exists in field NAME and it is not a fine solution)
>
>Thanks,
>Petr Valach
I think, you can trap the appropriate error in error handler and ask user to either reenter the value or revert the table....
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer