> It's a serious flaw in design to try to work around concurrency

protection

> in the way you are trying to do it. It doesn't work; and you are

risking

> unpredictable logical corruption. (Logical corruption means bad

data that

> isn't detected by the engine).
>
> Helen

Hi Helen,

Basically, the design flaw is in the missing UNIQUE CONSTRAINT of the
(supplierid, invoicenumber) pair, isn't it?