Error in sort processing

[Kenneth Brody]

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