|Subject||Re: [IBO] transaction behavior|
> It's a serious flaw in design to try to work around concurrencyprotection
> in the way you are trying to do it. It doesn't work; and you arerisking
> unpredictable logical corruption. (Logical corruption means baddata that
> isn't detected by the engine).Hi Helen,
Basically, the design flaw is in the missing UNIQUE CONSTRAINT of the
(supplierid, invoicenumber) pair, isn't it?