Hi,

I have a dropdown in the html page and Iam dynamically populating this dropdown through this query as shown below:

-SET &ECHO='ALL';

ENGINE SQLMSS SET DEFAULT_CONNECTION DBD
SQL SQLMSS PREPARE SQLOUT FOR
SELECT A FROM TABLE1
Where A = 'TITLE' and NUM=2 and ID='90';
END

TABLE FILE SQLOUT
PRINT A
END
-RUN

The dropdown will show these values namely :
XYZ
ABX
SEZ
MNOP etc

I need to add "ALL" option to this above list....Since Iam using a dynamic way[fex] to populate the dropdown,Iam not able to add the "ALL" option in the HTML Composer page itself.

Could anyone please suggest any other way to add the "ALL" option in the fex itself[By adding HTMLFORM BEGIN method just below the fex code or through any other means].

Any help is greatly appreciated!

Thanks a lot in advance!

Regards!

This message has been edited. Last edited by: info4pal,

Add "All" in the table?

Hi MattC,

Thanks for the response.
Is there any other way to add it in the fex itself rather than adding it in the table..

Regards!

Hi,

Thanks MattC!

Regards!

quote:

to add it in the fex itself rather than

Create another HOLD with 'ALL' and then use MORE or MATCH to append to existing list of values.

Thanks,
Ram

Hi,

Thanks a lot Ram!

Regards!