Re: Stored Programs/Triggers

Impy wrote: > "John Carlson" <john_carlson@whsmithusa.com> wrote in message > news:4f52cvc3cmbdjmhne57v2nlm2ba80vmf07@4ax.com... > >>On Tue, 13 May 2003 10:57:56 -0500, "Impy" <impy2101@yahoo.com> wrote: >> >> >>>"John Carlson" <john_carlson@whsmithusa.com> wrote in message >>>news:pr42cvgh79s416pq1qgltq6rqhpdp6qfv6@4ax.com... >>> >>>>On Tue, 13 May 2003 10:17:13 -0500, "Impy" <impy2101@yahoo.com> wrote: >>>> >>>> >>>>>Is it possible to query the entire database to determine if there are >>>>>triggers or stored 4gl programs in the tables? I see in DBAccess I can >>>> >>>check >>> >>>>>for triggers on individual tables. >>>>>Thanks! >>>>> >>>> >>>>Triggers can be found in systriggers and systrigbody. >>>>Stored 4gl programs??????? >>> >>>I'm working on an upgrade project - it was a question asked of me: "Does >> > the > >>>client have any 4gl stored programs?" >>> >> >>I thought I had heard and seen a lot, but I've missed this one . . .. >>what is a 4gl stored program? Or should I say, what is 'their' >>definition? > > Definition? Don't be ridiculous - they didn't provide one. I'm assuming it's > some kind of customization for the program. This is 'their' program I'm > upgrading (using 'their' checklist)...I would think 'they' would have > records and documentation if they had provided us with customizations - > however, any ineptitude on 'their' part never surprises me. > Thanks for your answer on the triggers! Do they mean stored procedures? Found in sysprocedures and sysprocbody, IIRC. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+