Hello

I have a drop down that is populated dynamically from a table. I checked 'Add ALL Option" in parameters to display ALL on top of values in drop down.

When ALL is selected, _FOC_NULL is sent to the fex in the background. Can we send a custom value directly from HTML page when ALL is selected without writing a SET in the fex?

Please suggest

Thanks.

This message has been edited. Last edited by: <Kathryn Henning>,

you'll have to be willing to write a fex to populate your dropdown, and not pull from a masterfile.
we do it this way. we never ever use the 'add ALL option';
Are you willing to do that?

quote:

Originally posted by susannah:
you'll have to be willing to write a fex to populate your dropdown, and not pull from a masterfile.
we do it this way. we never ever use the 'add ALL option';
Are you willing to do that?

hi Susannah

how do we get ALL option when populating from a fex? even when we use master file, backend its a procedure correct.

ok, i'll write you a little fex.
give me 10 mins, and i'll update this post with a fex you can run on the car file.

APP PATH IBISAMP
 
TABLE FILE  EMPLOYEE
  PRINT COMPUTE NAME/A30=LAST_NAME || ', '|FIRST_NAME ; BY EMP_ID
 
ON TABLE HOLD AS H2
END
DEFINE FILE  EMPLOYEE
EMP_ID/A9 WITH LAST_NAME='ALL';
 NAME/A30 WITH EMP_ID='MY EXES LIVE IN TEXAS';
END
 
TABLE FILE EMPLOYEE
PRINT EMP_ID  NAME  
IF RECORDLIMIT IS 1
ON TABLE PCHOLD FORMAT XML
MORE
FILE H2
END

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

thanks Susannah..made changes to master file and added All record to database. this helped so that we don't need to change any reports.