>
> The problem is the LockWait or the the Before Insert trigger
> with the dummy update SET STATUS = STATUS ?!?!
>

now i'm debugging the trigger BI_INSERT_INV_NUM
and it seems to be fired only when the client post insert and
not when client insert row so what's is written in the technical information
sheet
is meaningless

***************************************************
Mix in a little conflict :

Free up some more invoice numbers by deleting some more headers.

Now, open another instance of the application by running the EXE from the
project folder.
Line up the two instances so that you can observe both the header and log
grids of both.

In one instance, start to enter a new header, but don't post it.

Do the same in the second instance but, this time, try to post it.
Observe that you get a Deadlock message.
This is not a problem - it shows that the lock applied in the Before Insert
trigger by the first instance is working.
***************************************************

i thought techincal information sheet, withe pages and so on
should clarify concepts not complicate it :-(

any help would be appreciate

Thanks in advance
Stefano Campri