Selection set with variables in processing

[Jeff Harrison]

----- Original Message ----

> From: Kenneth Brody <kenbrody at spamcop.net>
> To: Jeff Harrison <jeffaharrison at yahoo.com>
> Cc: "Filepro-List at Lists. Celestial. Com" <filepro-list at lists.celestial.com>
> Sent: Tue, December 21, 2010 8:57:08 AM
> Subject: Re: Selection set with variables in processing
> 
> On 12/21/2010 1:18 AM, Jeff Harrison wrote:
> [...]
> >>> 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.)
> >>
> >> 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.
> >
> > 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.
> 
> Well, as I said:
> 
> > (Of  course,  such a selection set is
> > meaningless from within a "normal"  scan for  records, as processing is not
> > run during the  scan.)
> 
> And, given the OP's wording:
> 
> > use them in a Selection  Set in a processing table
> 
> he's not using it as part of a scan, but rather  within processing itself.
> 
> -- 
> Kenneth Brody
>

I did not see where he said that it was not to be used as part of a scan (But 
perhaps you are correct).  It IS possible to use the selection set in processing 
as part of a system (report, clerk, etc.) command.  At any rate he was not 
explicit as to how it was to be used.

It is of course also possible to use it the way you described above, except have 
filepro write the processing table instead of manually editing it.

Jeff Harrison
jeffaharrison at yahoo.com
Author of JHExport and JHImport