Selection set with variables in processing

Kenneth Brody kenbrody at spamcop.net
Tue Dec 21 05:57:08 PST 2010


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


More information about the Filepro-list mailing list