hi everybody!

i would like to make a webfocus dynamic dropdown list in frontpage. everything works well, but the value to be dynamic is the year. my problem is that i get as many years as there are datasets :-( but i only want one occurance per year...
how can i solve this.. maybe there is a simple and quick solution, but i don�t have an idea about it...
would be great to get some hints from you...

greets from sunny autria!
thnx ernst

I'm not a pro at drop-downs but are you doing a SUM and BY on your YEAR field.....


I'm sure there are other ways but here is a
code example of one of our year drop-downs
TABLE FILE BU01TB06
SUM
COMPUTE YEARVAL/A8 =
IF CD_YEAR EQ '&TRANS' THEN 'SELECTED' ELSE ' ' ; NOPRINT
COMPUTE OPC/A128 =
''||
CD_YEAR||'';
ON TABLE SET HOLDLIST PRINTONLY
BY CD_YEAR NOPRINT

ON TABLE HOLD AS YEARIS FORMAT ALPHA
END
-RUN

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

quote:

Originally posted by webfocuspgm:
[qb] I'm not a pro at drop-downs but are you doing a SUM and BY on your YEAR field.....


I'm sure there are other ways but here is a
code example of one of our year drop-downs

...

[/qb]

Hi and thanks for your suggestion..
Hmm, sorry i really don�t know how to use ist...

i am working with frontpage and there i create a dynamic dropdown with the field "year"... but as i mentioned before i get hundreds of the same year.. and i only want one per year.. maybe i can manipulate the year in the fex using distinct or smthg like that, but i don�t know how to make this work or which tool to use...

hi!

i read about SQL statements in webfocus:
her you can use SELECT DISTINCT .....

is there a possibility to use this for my problem?
i would like to make a dynamic dropdown in frontpage with only one row for each year of my database.

...or are there any other suggestions and ideas?

quote:

maybe i can manipulate the year in the fex using distinct or smthg like that

How are you creating the drop down list - can you please show us the fex?

Thanks.

hi! found a solution myself... just one thing.. i need date format and in the example is alfanumeric.. but if i fix this, it will probably work..


http://techsupport.informationbuilders.com/ibase/master...ex.htm#codingui7.htm

sorry pietro didn�t see your answer till now..
in my fex there is the missing variable/field. so fex would be useless four you..