Helen Borrie wrote:

> Two transactions can't update the same doc number record, so, the
> first to post the update will win. Your transaction should be No
> Wait and your trigger must handle such conflict exceptions itself and
> move on through the doc numbers until it gets one that is not in conflict.
>

That works with read committed transactions. Concurrency/snapshot
transactions will always see the conflicting result.


Regards,


Ann