Getting Initiator's UserID for an External -v table process

Stanley - stanlyn.com stanley at stanlyn.com
Sat Aug 27 15:08:09 PDT 2016


Hi Ken

>> Of course, @ID is already available in the dreport you're calling so I'm not sure I follow what, exactly, you want to do.)

No, that’s the issue, as from the called report, the @id has value of "filepro" and not "root" who was the initator.  That is the problem.

I'm trying your suggestion and will report back and thanks...

Stanley




-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
Sent: Saturday, August 27, 2016 5:36 PM
To: Stanley - stanlyn.com <stanley at stanlyn.com>; filepro-list at lists.celestial.com
Subject: Re: Getting Initiator's UserID for an External -v table process

On 8/27/2016 5:27 PM, Stanley - stanlyn.com via Filepro-list wrote:
[...]
> What would be ideal would be to pass a parameter to/with the system 
> call such as:
>  system "/appl/fp/dreport sdgl_detail -f GlDetail -A -u -v gldetail 
> _select -h 'Printing GL Detail Report' with @id"
>
> Notice the "with @id" at the end as the parameter.  I know this is 
> illegal in filepro, just need to be able to do the same.

I'm not sure what you mean by "with @id".  However, there are several "-r" 
parameters you can pass to *report, and each one sets a different system field:

     -r    Sets @PM
     -rw   Sets @PW
     -rx   Sets @PX
     -ry   Sets @PY
     -rz   Sets @PZ

For example:

     system "/appl/fp/dreport ... -rz '" & @id & "'"

This would set @PZ to the current value of @ID.  (Of course, @ID is already available in the dreport you're calling so I'm not sure I follow what, exactly, you want to do.)

--
Kenneth Brody



More information about the Filepro-list mailing list