Обсуждение: TRIGGERS - access sql query_string that called it?

Поиск
Список
Период
Сортировка

TRIGGERS - access sql query_string that called it?

От
Matthew Peter
Дата:
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?

От
Richard Huxton
Дата:
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