Error in sort processing

Don Coleman dcoleman at dgcreact.com
Thu Feb 15 08:20:41 PST 2007


I have a customer who occasionally receives the following error when running
their delivery sheets (packing slips).  The output format is a report.

Error line 199
Edit name YESNO
Field 0
@RN 79503

When this error normally occurs I am not on-site.  However, yesterday I was.
I was able to run the delivery sheet by excluding this record and then
running the process again selecting only this record.  Using this method did
not produce the error.  However, this is not the desired method of running
their delivery sheets.  There were 105 total records selected.  The data
referenced in line 199 follows line 199:

Apologies in advance for the formatting below.
 


Feb 15, 2007  10:20           File Name: QS1                       Page   1
                             Processing: Selrecon

 197 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
41sort   If: 108 eq "Y" and 74 eq "Y"
 
Then:sort1=9;sort2(1,YESNO,d)=74;sort3(1,YESNO,d)=74;sort4=96;sort5=52
;sort6(30,ALLUP)=11{12{13;sort7=22;end
 198 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 108 eq "Y"
 
Then:sort1=9;sort2(1,YESNO,d)=74;sort3(1,YESNO,d)=74;sort4=96;sort5=52
;sort6(30,ALLUP)=11{12{13;sort7=22;end
 199 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then:
sort1=9;sort2(1,*,d)=mid(1,"1","1");sort3(1,*,d)=mid(1,"1","1");
          sort4=96;sort5=52;sort6(30,ALLUP)=11{12{13;sort7=22;end

sort1 data = FX (field 9 edit is 4,ALLUP)
sort2 data = 0 mid(1,"1","1") (field 1=09616053, edit is 8,*)
sort3 data = 0 mid(1,"1","1") (field 1=09616053, edit is 8,*)
sort4 data = 1 (field 96 edit is 1,.0)
sort5 data = "" (blank single character field) (field 52 edit is 1,*) 
sort6 data = FAIRFAX COUNTY AD (field 11 edit is 17,ALLUP) 
             ULT DE. CNT. (field 12 edit is 12, ALLUP)
             "" (blank single character field) (field 13 edit is 1,ALLUP) 
sort7 data = Zosyn 3.375gm Mini Bag Pl (field 22 edit is 25,*)


Can anyone tell me why this line errors out?  If I am understanding the
error correctly it seems like one of the sorts is attemting to process a
field containing a 0 (zero) where the edit is defined as YESNO.  I guess the
two likely candidates are sort2 and sort3 because the both contain a 0
(zero) but the field is defined as edit = *.  I'm at a loss (again!).


Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
dcoleman at dgcreact.com
(724) 349-6302




More information about the Filepro-list mailing list