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

[Richard D. Williams]

Stanley,

This should work;

system "/appl/fp/dreport sdgl_detail -f GlDetail -A -u -v gldetail_select -h \"Printing GL Report\" -RZ \""&@id&"\""

Richard



On 8/27/2016 5:28 PM, Stanley - stanlyn.com via Filepro-list wrote:
> Hi Ken,
>
> Reporting back...
>
> Executing:
> system "/appl/fp/dreport sdgl_detail -f GlDetail -A -rz -u -v gldetail_select -h 'Printing GL Report'"& @id & "'"
>
> Gets me this error...
>
> *** A filePro Error Has Occurred ***
> Command Line: /appl/fp/dreport sdgl_detail -f GlDetail -A -rz -u -v gldetail_sel
> ect -h Printing GL Reportroot
> Bad argument on command line.
>
> It passes the syntax checker...
>
> I played with the single and double quotes and all attempts failed.
>
> 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
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
>