| Subject | Get SQL Query in Trigger |
|---|---|
| Author | matf_de |
| Post date | 2006-09-10T09:36:09Z |
Hi !
Is it possible to get the SQL Statement which causes the execution of
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.
Is it possible to get the SQL Statement which causes the execution of
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.