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

[Stanley - stanlyn.com]

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