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