|Subject||Re: FB 2.1 - new DB trigger feature with MON$ tables|
> I figured this would allow me to check a user's database and find outPaul,
> why they reported an error. Unfortunately it never works. The
> MON$TRANSACTION_ID is always null.
> Is this possible to do?
The reason your SQL is not being logged is that your transaction is
rolled back by your application.
Although the monitoring triggers would be an interesting way of
implementing such a feature, there is another way that will work in
any version of Firebird. External tables are outside the context of a
transaction, so if you were to insert the SQL into an external table,
it will be there for you to investigate even if you rollback.