Re: insert ROW LEVEL trigger question

Posted in 1995

Topics: Stored Procedures & SPL, Triggers, Constraints & Referential Integrity

E.F. Codd Wanna be — Wed, 29 Nov 1995 09:17:24 GMT — source: Informix-list mailing list archive (1991-1998)

nigelc@Cognos.COM (Nigel Campbell) wrote: >I cannot tell from the Online 7.x docs if I should be able to setup a row >level insert trigger which assigns values to columns of the inserted row >via calls to a stored procedure. As along the lines of execute procedure >blat ... into col1, col2... in an update trigger. >Ideas? >-- >Nigel Campbell Voice: (613) 738-1338 ext 3016 P.O. Box 9707,Stn.T >Business Intelligence FAX: (613) 738-0002 3755 Riverside Dr. >Cognos Incorporated Internet: nigelc@cognos.com Ottawa ON K1G 4K9 > URL: http://www.cognos.com CANADA I have been wrestling with this very problem for about two days now. I believe I may stumbled upon a work around, but I am still testing it out. I will post a followup when I finally get it working. -------------------------------------------------------------------------------- Robert Entrican AppWorks, Inc. - Yorba Linda CA entrican@exo.com