Error in sort processing

[Don Coleman]

> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at bestweb.net]
> Sent: Friday, February 16, 2007 12:05 PM
> To: Don Coleman
> Cc: filepro-list at lists.celestial.com
> Subject: RE: Error in sort processing
> 
> Quoting Don Coleman (Thu, 15 Feb 2007 12:00:20 -0500):
> 
> > Per Ken's request (Top Post):
> >
> > *** a filePro Error Has Occurred ***
> >
> > On File: \QS1\TODO/filepro/exclude/index.A
> >
> > Input Processing
> > Line Number: 199
> > Edit Name: YESNO
> > Record Number: 79503
> > Field: 0
> >
> > Edit failed
> 
> Well, as it says, "0" is not a valid value for a YESNO field.
> 
> [...]
> > > >  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
> [...]
> 
> Are you expecting that you can change the sort type mid-sort?  You
> sometimes set sort2 and sort3 to YESNO fields, and other times you
> set them to "*" fields.
> 
> What happens when the first record encoutered has 108="Y" and you
> then encounter a record which fails that test, and has a "0" in
> the first character of field 1?  (Or are you guaranteed that field
> 108 will either be always "Y" or always not-"Y"?)
> 
> --
> KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com


Thank you Ken.  I was thinking about this as a problem with an individual
record, not a collective group of records.  There should be no records that
conditionally meet more than one line in lines 197-199.  Field 108=Y
indicates this is an order run from their new application (CIPS), all
non-CIPS orders would be 108=N.  I will adjust as suggested.  Thanks again.



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