Subject RE: [firebird-support] "lock conflict on no wait transaction" exception - Email found in subject
Author Leyne, Sean
> FB 1.5, Dialect 3
> I am getting a "lock conflict on no wait transaction" on a table that I
> only insert data into. The table is a log file for changes to a
> different table (ClientInfo)--the inserts happen from ClientInfo's
> BeforeUpdate trigger.
> Here is the SQL from the BeforeUpdate that of the ClientInfo table

Very odd, nothing that obvious to me.

Have you tried changing the trigger to an AfterUpdate?

For "change logging" functions, AfterUpdate is more appropriate because the Update could actually be stopped by another BeforeUpdate trigger or constraint enforcement. Whereas, in an AfterUpdate trigger the operation has taken place, you are simply acting on the effect of the change.