Subject Re: [firebird-support] problem with insert/commit moment
Author Martijn Tonies

> My problem is that 'NOW' is the insert moment and not the commit
> moment, so, if the user insert a record and commit it after few
> minutes, I don't have a correct image of my data. Is there a way to
> register the commit instant? As far as I know it's not possible
> through triggers because they are active before or after INSERT (or
> update...) and not before or after COMMIT, but maybe someone had the
> same problem and now there is a solution...

In my opinion, letting the user control actual database transactions is
asking for trouble.

Why not insert/update everything you want in a single batch and commit
after that?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!