|
> -----Original Message----- > From: Scott Mildenberger [SMTP:Smildenber@Washcorp.com] > Sent: Wednesday, November 07, 2001 1:12 PM > To: 'midrange-l@midrange.com' > Subject: RE: Recieving Data Decimal error in Trigger > > Comments inline. > > > -----Original Message----- > > From: Hartman, Richard [mailto:richard.hartman@brctsg.com] > > Sent: Wednesday, November 07, 2001 11:21 AM > > To: 'midrange-l@midrange.com' > > Subject: Recieving Data Decimal error in Trigger > > > > > > Hello all, > > > > > I am having a problem with a few trigger programs and > > cannot figure them > > > out. > > > When I compare the fields before image and after image I am > > recieving a > > > data > > > decimal error. > > > Any help would be appreciated. > > > Thanks > > > Richard > > > > > > Here is the before images. > > > EVAL BRECIMAGE > > > BFFOPYEAR OF BRECIMAGE = 0000. > > > BFFOLCDT Z OF BRECIMAGE = ' ' > > > BFFODATE D OF BRECIMAGE = ' ' > > > BFFOTXBLNO OF BRECIMAGE = ' ' > > > BFFODATE OF BRECIMAGE = ' ' > > > BFFOAMT OF BRECIMAGE = 000000000.00 > > > BFFOCTLNO OF BRECIMAGE = 000000000. > > > BFFOLCUSER OF BRECIMAGE = ' ' > > > BFFOLCDT OF BRECIMAGE = ' ' > > > > > > Here is the after image. > > > EVAL ARECIMAGE > > > AFFOPYEAR OF ARECIMAGE = 2000. > > > AFFOLCDT Z OF ARECIMAGE = '' > > > AFFODATE D OF ARECIMAGE = '' > > > AFFOTXBLNO OF ARECIMAGE = ' 22900' > > > AFFODATE OF ARECIMAGE = '2000-05-15' > > > AFFOAMT OF ARECIMAGE = 000000200.00 > > > AFFOCTLNO OF ARECIMAGE = 000263966. > > > AFFOLCUSER OF ARECIMAGE = 'RICHARDH ' > > > AFFOLCDT OF ARECIMAGE = '2001-11-02-16.53.23.475000' > > > > > > The AFFOLCDT Z and AFFODATE D values are highlighted in > > debug, like they > > > have the > > > data decimal problem. But those fields are not defined in my file. > > > The trigger program is jumping down into my PSSR routine > > when it evaluates > > > > > What do you mean those fields are not defined in the file? If they aren't > in the file then why are they part of your after record? In the before and after image they show up when ever a date field or timestamp is in the record format. Because field FODATE and FOLCDT are defined in the file the before and after image always has adds the fields FODATE D and FOLCDT Z. I have no idea why it does that though, does that in all our triggers that have date or timestamp fields in them. > > > this line > > > IF BFFOAMT <> AFFOAMT > > 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? > > > > > > Here is the file layout. > > > Field > > > Name Type Length Dec > > > FOPYEAR P 4 0 > > > FOTXBLNO A 10 > > > FODATE L 10 > > > FOAMT P 11 2 > > > FOCTLNO P 9 0 > > > FOLCUSER A 10 > > > FOLCDT Z 26 > > > > > > Only other thing I can think of is that you don't have the buffers mapped > properly, would have to see the code to determine that. > > Scott Mildenberger > _______________________________________________ > 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.