Hi All,

I need to align the Prompt values in Descending order. How can I achieve it.
The prompt is Year which values from 2009 to 2014 and it is a dynamic value fetching from the table.

I need the current year to be selected always.

Your inputs are highly appreciated.

Thanks is advance.

WebFocus 8.0.0.3

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

 TABLE FILE EMPDATA
SUM HIREDATE
BY HIGHEST HIREDATE
ON TABLE PCHOLD FORMAT XML
END
 

Hi

If you are looking for a solution for the AutoPrompt facility you can use the example Rifaz gave save it in a fex and then use it within the master file as source for dynamic list of values, for example:

FIELDNAME=HIREDATE, ALIAS=HDAT, USAGE=YMD,
ACCEPT=FOCEXEC (HIREDATE AS HIREDATE IN ibisamp/empdata_dates), $

This works with 8005 but I think its supported since 8002M

Thank you all.

It was helpful and I appreciate your inputs.