Setting a Report Parameter to value returned from SQL statement 1

LeonelSanchezJr · Feb 10, 2004

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 · Feb 11, 2004

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 · Feb 12, 2004

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Setting a Report Parameter to value returned from SQL statement 1

LeonelSanchezJr

Programmer

kiddpete

MIS

WFGuru

Vendor

Similar threads

Part and Inventory Search

Sponsor