Selection set question
Barry Wiseman
bwiseman at optonline.net
Wed Nov 14 08:05:35 PST 2007
Don Coleman wrote:
> 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?
A cumbersome but possibly workable approach would be a pair of selection
entries like this:
9 eq IY
9 lt IY!
Since "!" is at the bottom of the ascii collation sequence, that might
successfully exclude longer entries that begin with "IY".
Back in the days when we were creating filePro, I argued for an
additional selection relation called "EX" (matches exactly), but it
didn't make the cut :-( .
More information about the Filepro-list
mailing list