[SOLVED] About Drop Down List with store procedure
this is my code :
in main fex :
SQL SQLMSS SET SERVER &CONNECTION SQL SQLMSS EX wftest.dbo.store ProcedureDropDown; TABLE FILE SQLOUT PRINT * ON TABLE HOLD AS test1 END TABLE FILE test1 PRINT down1 NOPRINT COMPUTE CARRNM/A100 = ''; ON TABLE HOLD AS test2 FORMAT ALPHA END -RUN
SQL SQLMSS SET SERVER &CONNECTION SQLMSS EX wftest.dbo.otherProced ; TABLE FILE SQLOUT PRINT * ON TABLE HOLD AS XSQLOUT END -RUN
the elaborated messgae fo FOC36232 states: "Each !IBI escape sequence must be terminated by a semi-colon." Perhaps you can start with concatenating a semi-colon to the end of each row in "test2", that just may do the trick for you...
October 19, 2009, 08:13 AM
Firstly as Doug says should be !IBI.FIL.test2;';
However that is totally incorrect
as !IBI.anything only works when embedded in an HTML page it does not work in WebFOCUS processes such as DEFINE, COMPUTE, PRINT etc.
Secondly If you wish to use that technique then you must construct valid HTML select/option syntax
<_body, <_select <_body
are substitutions because you forgot to wrap the code in code tags
There are many examples available on the forum do a search for DEFINE SELECT OPTION You'll find exactly what you need.
October 19, 2009, 10:56 PM
thank you Doug thank you JG
i fixed it , i changed the 'test2' to 't2' , it's worked.. i don't know the reason...