TRIGGERS - access sql query_string that called it?
Started by Matthew Peterover 19 years ago2 messagesgeneral
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?
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