This almost works. When I select more than one option I get an Oracle error message.
QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0446 Oracle returned an error message.
ORA-00920: invalid relational operator
UDA-SQL-0450 An unexpected...
I'm trying to use radio buttons on my prompt page that will pass the parm value to my SQL.
I have the 4 separate buttons each with their own parm. Each button is set up with a collection like this
Button 1 ...
Use Display
1 VA
Button 2 ...
Use Display
1 PHS
etc...
The SQL where...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.