>>Thanks again. So basically COUNT FOR +Trapping uniqueness of index is violated error should work. I have to think about it and discuss with my colleagues. I can make changes for the particular form, but it's better to make the changes on the class level.
>
>I prefer the SELECT COUNT(*) on the buffered view/table because the count is retrieved into a cursor and leaves the source table as is with the record pointer on the same edited record.
Mark,
AFAIK, SQL works with table directly, in other words, it would not see the buffered changes. What's why this method in not 100% correct.
If it's not broken, fix it until it is.
My Blog