RE: Recieving Data Decimal error in Trigger

["Hartman, Richard" <richard.hartman@xxxxxxxxxx>]

Okay, thanks I think that is my whole problem.
I just remembered a few earlier trigger programs were checking the before
and after images only on an update..
Thanks for your help..
Richard

> -----Original Message-----
> From: Scott Mildenberger [SMTP:Smildenber@Washcorp.com]
> Sent: Wednesday, November 07, 2001 2:13 PM
> To:   'midrange-l@midrange.com'
> Subject:      RE: Recieving Data Decimal error in Trigger
>
> On an insert the old buffer is undefined because there isn't an old
> record.
> On a delete the new buffer is undefined because it isn't being created.
> On
> an update both buffers are defined.
>
> Scott Mildenberger
>
> > -----Original Message-----
> > From: Hartman, Richard [mailto:richard.hartman@brctsg.com]
> > Sent: Wednesday, November 07, 2001 12:54 PM
> > To: 'midrange-l@midrange.com'
> > Subject: RE: Recieving Data Decimal error in Trigger
> >
> > > Are you only accessing this line when the trigger fires on
> > an update?  On
> > > a
> > > delete or insert one of these values won't be defined and
> > shouldn't be
> > > accessed.
> > On update or insert. Why wouldnt the values be defined?
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.