Error in sort processing

[GCC Consulting]

> -----Original Message-----
> From: 
> filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> .com 
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
> elestial.com] On Behalf Of Don Coleman
> Sent: Thursday, February 15, 2007 11:21 AM
> To: filepro-list at lists.celestial.com
> Subject: Error in sort processing
> 
> 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

In addition to Ken's request, have you looked at this record and checked the
values in any yesno fields?

Richard Kreiss
GCC Consulting
 



> 
> 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
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>