Subject | Re: Get SQL Query in Trigger |
---|---|
Author | Adam |
Post date | 2006-09-10T11:47:25Z |
> Is it possible to get the SQL Statement which causes the execution ofNo you can't.
> a trigger in the trigger script ?
>
> for example:
> I perform: UPDATE test SET field=1 WHERE id=5
>
> so I want to get this string in a variable when the Trigger for Update
> Statements is fired for the table test.
>
You can look at the old and new values for each field and from that
generate a statement, but that is not the quite same thing, might be
close enough for your needs though.
Adam