Re: Stored Programs/Triggers

On Thu, 15 May 2003 19:30:18 +0100, Paul Watson <paul@oninit.com> wrote: I'll bet versioning their programs would be fun, then . . . .8-) >Maybe they insert their 4ge into a byte field for safe keeping :-) > >John Carlson wrote: >> >> 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?