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