Selection set question
Bruce Easton
bruce at stn.com
Wed Nov 14 07:55:31 PST 2007
Don Coleman wrote Wednesday, November 14, 2007 10:24 AM:
>
> I have a select table which builds a selection set in a file via an ascii
> export and then runs system to generate a report using the exported
> selection set. My problem is one of the selection set's criteria is
> facility code (field #9). As this customer adds on new customers
> they have
> begun to use facility codes which have the first several
> characters the same
> (ex: IY, IYCC, IYCS, IYCJ). The application is making a match on what it
> can and is selecting more than the one I really want, in this
> case facility
> code IY. I don't have much control over the facility code, as it enters
> filePro via import and socket connections from two alien
> applications. The
> relevant portion of the select table is below. Is there a way to have the
> selection set make only exact matches?
>
> Nov 14, 2007 10:14 File Name: QS1
> Page 1
> Processing: Selrecon
>
> 23 ------- - - - - - - - - - - - - -
> - - -
> noctl If:
> Then: RF="E:\QS1\TODO\FILEPRO\QS1\DOUBLE.SEL"{""
> 24 ------- - - - - - - - - - - - - -
> - - -
> If:
> Then: export ascii use=(RF) f=\n
> 25 ------- - - - - - - - - - - - - -
> - - -
> If:
> Then: use(1)="";use(2)=":9:eq:"{AB;use(3)=":150:eq:"{"Y"
> 26 ------- - - - - - - - - - - - - -
> - - -
> If:
> Then: use(4)=":66:eq:"{@td
> 27 ------- - - - - - - - - - - - - -
> - - -
> If: 9 eq "MTSP" and AC eq "A"
> Then: use(5)=":4:eq:LRL";goto montana
> 28 ------- - - - - - - - - - - - - -
> - - -
> If: 9 eq "MTSP" and AC eq "D"
> Then: use(5)=":4:ne:LRL";goto montana
> 29 ------- - - - - - - - - - - - - -
> - - -
> If: 9 eq "MTWP" and AC eq "A"
> Then: use(5)=":4:eq:LRL";goto montana
> 30 ------- - - - - - - - - - - - - -
> - - -
> If: 9 eq "MTWP" and AC eq "D"
> Then: use(5)=":4:ne:LRL";goto montana
> 31 ------- - - - - - - - - - - - - -
> - - -
> If:
> Then: use(5)=""
> 32 ------- - - - - - - - - - - - - -
> - - -
> montana If:
> Then: use(6)=":::";use(7)=":::";use(8)=":::";use(9)=":::"
> 33 ------- - - - - - - - - - - - - -
> - - -
> If:
> Then:
> use(10)=":::";use(11)=":::";use(12)=":::";use(13)=":::";use(14)="
> ";goto finsel
> 34 ------- - - - - - - - - - - - - -
> - - -
> finsel If:
> Then: write use;close use
> 35 ------- - - - - - - - - - - - - -
> - - -
> If:
> Then: RE(70,*)="E:\FP_SETUP_FILES\FP5.0.13\FP\RREPORT QS1
> -F DOUBLECK
> -S
> DOUBLE -U"
> 36 ------- - - - - - - - - - - - - -
> - - -
> If:
> Then: system RE
>
>
> Don Coleman
Don, try building your selection set with two lines for
the facility code (they should be "and'ed", not "or'ed")
as follows:
9 lt AB{"@"
9 ge AB
Use a non-blank printable ascii char (that doesn't have
special use by filepro) lower than the lowest ascii char
that's legal in your facility code in place of the "@"
above. (For instance, if the facility code allows numerals
and chars only, you should be able to use a period.)
Bruce
Bruce Easton
STN, Inc.
More information about the Filepro-list
mailing list