Selection set with variables in processing

[Jeff Harrison]

----- Original Message ----
> From: Richard Kreiss <rkreiss at gccconsulting.net>
> To: Kenneth Brody <kenbrody at spamcop.net>; Boaz Bezborodko <boaz at mirrotek.com>
> Cc: "Filepro-List at Lists. Celestial. Com" <filepro-list at lists.celestial.com>
> Sent: Mon, December 20, 2010 1:14:54 PM
> Subject: RE: Selection set with variables in processing
> 
> 
> 
> > -----Original Message-----
> > From:  filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> >  [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com]  On
> > Behalf Of Kenneth Brody
> > Sent: Monday, December 20, 2010  12:29 PM
> > To: Boaz Bezborodko
> > Cc: Filepro-List at Lists. Celestial.  Com
> > Subject: Re: Selection set with variables in processing
> > 
> > On 12/19/2010 2:13 PM, Boaz Bezborodko wrote:
> > > How do I use  Selection Sets with variables in a processing table?
> > >
> > > I  want to let the user enter a couple of variables and use them in a
> > >  Selection Set in a processing table.  I've never actually use a
> >  > selection set in this way so I was wondering how this is done.
> > 
> > Well, you'll have to "cheat" a little, since filePro won't let you  create
> a
> > selection set with dummy fields in it.
> > 
> >  Create the selection set that you want, but substituting real fields  where
> you
> > want the dummy fields.  Then using your favorite text  editor, replace the
> > occurrences of the real fields with the dummy fields  you want.  For
> example,
> > change:
> > 
> >       :1:co:foo
> > to
> >      :aa:co:foo
> > 
> > You can then refer to that selection set in processing, and filePro  will
> use the
> > dummy fields as defined in processing.  (Of course,  such a selection set
> is
> > meaningless from within a "normal" scan for  records, as processing is not
> run
> > during the scan.)
> > 
> >  --
> > Kenneth Brody
> 
> I still think that using -v select processing  would solve his problem and
> allow for more flexibility than using a selection  set in a very non-standard
> manner.
> 
> 
> 
> Richard Kreiss
> GCC  Consulting
> rkreiss at gccconsulting.net
>   

Yes, but Ken's solution is very cool.

Another way to do this would be to use the file IO commands (jsfile, write, 
writeline, etc.) to write out the selection set.  You could do this say in @menu 
processing in clerk for example.  Then close the file, and do a system command 
to do the actual report calling the selection set you just created.  


Jeff Harrison
Author of JHExport and JHImport.