[GENERAL] Searching through trigger functions

2011-09-26 Thread Bob Pawley
Hi I have an error somewhere in one of the trigger functions in my database. The error message only told me it was a ‘Select * From (table name). Is there a global method of finding where this expression resides other than searching each script individually. Bob

Re: [GENERAL] Searching through trigger functions

2011-09-26 Thread Merlin Moncure
On Mon, Sep 26, 2011 at 12:47 PM, Bob Pawley rjpaw...@shaw.ca wrote: Hi I have an error somewhere in one of the trigger functions in my database. The error message only told me it was a ‘Select * From (table name). Is there a global method of finding where this expression resides other than

Re: [GENERAL] Searching through trigger functions

2011-09-26 Thread Alan Hodgson
On September 26, 2011 10:47:20 AM Bob Pawley wrote: Hi I have an error somewhere in one of the trigger functions in my database. The error message only told me it was a ‘Select * From (table name). Is there a global method of finding where this expression resides other than searching each