Setting a Report Parameter to a field from a Oracle table

[LeonelSanchezJr]

I have a report that should default to
a user's default location:
so, i have the following code, but
i am getting errors.

SQL ORA
select t.locationid AS ORG_STA from tr_user_master t
WHERE Upper(t.userid) = Upper('&MRUSER');
TABLE FILE SQLOUT
PRINT ORG_STA
ON TABLE HOLD AS HLDFIELD FORMAT ALPHA
END
-SET &ORIGIN_STA = '&HLDFIELD.ORG_STA';


Thanks,

Leo ;-)

 

[WFGuru]

What's the error you're getting? By "default location" do you mean the Oracle SID? Does the SQL work in SQL*Plus?

 

[LeonelSanchezJr]

The SQL returns the correct "default location".
The default location is just a default parameter for
the report.

The problem occurs at the -SET &ORIGIN_STA = '&HLDFIELD.ORG_STA'; line

The error states that it doesn't recognize the '&HLDFIELD.ORG_STA' field.



Thanks,

Leo ;-)

 

[WFGuru]

That -SET statement doesn't make sense. If you're trying to set a WebFOCUS &variable to the returned value of the Oracle column, see my reply to your other posting.