Thread: TRIGGERS - access sql query_string that called it?

TRIGGERS - access sql query_string that called it?

From
Matthew Peter
Date:
Is it possible to access the entire sql query_string that called the trigger?




____________________________________________________________________________________
Want to start your own business?
Learn how on Yahoo! Small Business.
http://smallbusiness.yahoo.com/r-index

Re: TRIGGERS - access sql query_string that called it?

From
Richard Huxton
Date:
Matthew Peter wrote:
> Is it possible to access the entire sql query_string that called the trigger?

No. It doesn't necessarily exist in any useful form (think about what
happens with rules on a view, or triggers making updates which fire
other triggers - what is the "original" query?).

--
   Richard Huxton
   Archonet Ltd