FW: Notification: Inbound Mail Failure

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01BF164D.8AFA286A Content-Type: text/plain; charset="iso-8859-1" please detete user address vanle ho -----Original Message----- From: HA/TMA Postmaster Sent: Thursday, October 14, 1999 6:16 AM To: HA/TMA Postmaster Subject: Notification: Inbound Mail Failure The following recipients did not receive the attached mail. A NDR was not sent to the originator for the following recipients for one of the following reasons: * The Delivery Status Notification options did not request failure notification, or requested no notification. * The message was of precedence bulk. NDR reasons are listed with each recipient, along with the notification requested for that recipient, or the precedence. <VanLe.Ho@tma.osd.mil> VanLe.Ho@tma.osd.mil MSEXCH:IMS:ORGANIZATION:ha:DDDC025 0 (000C05A6) Unknown Recipient Precedence: bulk The message that caused this notification was: <<Re: Update table's column in table's trigger>> ------_=_NextPart_000_01BF164D.8AFA286A Content-Type: message/rfc822 Message-ID: <3805B9AF.BFF80467@netinfo-moldova.com> From: Octav Chiriac <com@netinfo-moldova.com> To: Mike <skillm@ozemail.com.au>, Informix Newsgroup <informix-list@iiug.org> Subject: Re: Update table's column in table's trigger Date: Thu, 14 Oct 1999 07:08:31 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" I have an idea, but I'm not sure it will be suitable for you. Just create a simple stored procedure like: create procedure _upper(f char(255)) returning char(255);return upper(f); end procedure; and then modify your trigger to look like: CREATE TRIGGER tri_composer INSERT on composer REFERENCING NEW as post FOR EACH ROW( execute procedure _upper( post.lastname ) into_ulastname); I didn't test it and I'm not sure it will work in all cases. Best Regards, Octav Mike wrote: > > How do I write a trigger to update a column in the table that is being > updated, based on a value from another column in the table? > > For example, in table composer, with columns lastname and _ulastname, this > doesn't work > > CREATE TRIGGER tri_composer INSERT on composer > REFERENCING NEW as post > FOR EACH ROW( post._ulastname = upper( post.lastname ) );> > Any help is greatly appreciated. > > Thanks > Mike Skillicorn -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com ------_=_NextPart_000_01BF164D.8AFA286A--