Selection set question
Mike Schwartz
mschw at athenet.net
Wed Nov 14 08:05:24 PST 2007
> 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
What is the length and edit type of field 9?
Have you tried something like:
use(2)=":9:eq:"{AB{""
I don't know if removing the trailing blanks would carry through to the
selection set. If that doesn't carry through to the selection set, you could
write additional sort-selection processing in the "Doublechek" report to
eliminate the unwanted records.
What I would really suggest is to rewrite the sort-selection processing
to eliminate both the export and the separate report call.
Mike Schwartz
More information about the Filepro-list
mailing list