> so I can't let A wait until B commits and then A will proceed?
>
> There isn't actually a conflict as they are updating different fields
> in a single-row table
>

the only thing I do to get close to this is B can be set to wait, and if A
rollbacks, then B can commit. If A commits, B won't be able to commit until
it first retrieves what A has done, then re-edits and commits. The wait
could be a long time in a manual user situtation.
Alan