Setting a Report Parameter to value returned from SQL statement 1

[LeonelSanchezJr]

I am running a SQL query
and I need to set the report parameter equal to the
value returned in the SQL query.


Thanks,

Leo ;-)

 

[kiddpete]

Access a file in Fixed Block mode. Write the SQL data to this file as a SAVE (ON TABLE SAVE AS 'whatever') file. Close the file, and use a -READ to read the values you want into Dialogue Manager variables.

 

[WFGuru]

SQL
<your query>
;
TABLE FILE SQLOUT
PRINT *
ON TABLE SAVE AS HOLDPARM
END
-RUN
-READ HOLDPARM &MYPARM.A(length).
EX <fexname> <parameter>=&MYPARM