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