Subject Re: SQL Statement that fired trigger?
Author bakasanchi
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:
>
>
> > I would like to know if someone knows of a way to get the SQL
> > statement that caused a trigger to fire?
>
> You cannot, you can only know if it's an insert, delete or update
> statement.
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
Oracle &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
Are you sure there is absolutely no way? But please do share how to
know if it's an insert, delete or update please.

Thanks
Anton