I have a list of a few hundred customers in a list box. Is there any way to put these customers in alphabetical order in a listbox?

Thanks!

Yes. I'm sure there's some javascript to do it, (i'm not a javascript person) but you can always run a procedure that sorts them alphabetically before holding them for your list box control. Lots of examples available in the forum

You don't indicate the source of the customer list you want to show in the listbox. I'm presuming you have a file/table somewhere that contains that.

Consider running a TABLE FILE ... against your Customer Master file to select the customers you need and hold that selection in a *.htm file. Precede the query with a FILEDEF pointing to a place in your FOCUS path. Include BY {customer-name-field} to sort them as you wish and an ON TABLE HOLD AS {filedef-name} to write the *.htm in the appointed place. Each row in the file must have the customer-name text you want preceded with an html 'select' tag consisting of the LT character, the word 'SELECT' and the GT character.

In your HTML/launch page, reference the content of the select box with !{name-of-held-file} which will cause the select box to be populated from the output of the afore mentioned query.

For this to work the launch page must be displayed by WF using a *.fex containing HTMLPAGE {name-of-launch-page-containing '!...'}.

If you need details, I can post example fex.

I agree with cburtt, I have some launch forms where I use the dynamic list boxes using a procedure (.fex) and create a TABLE FILE for that list
CREATE A FEX CALLED "CUSTOMERLIST.FEX"
DEFINE FILE TABLE1
CUST/A120=CUSTOMERNAME|' : '| CUSTOMERID;
END
TABLE FILE TABLE1
SUM CUST AS 'CUSTLIST'
BY CUSTOMERID
ON TABLE PCHOLD FORMAT XML
END

And here's the statement from html




Hope it helps

-P

heres the select tag for htm

"SELECT language=javascript id=listbox6 style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; Z-INDEX: 24; LEFT: 30px; WIDTH: 450px; FONT-FAMILY: Arial; POSITION: absolute; TOP: 120px; HEIGHT: 360px" tabIndex=23 onchange=listbox6_onchange(this) size=3 name=CMISRPTS sourcetype="typeFex" ibiapp_app="cmisreports" ibic_server="EDASERVE" datatype="1" datafield displayfield datasource="CUSTOMERLIST.FEX">

CHANGE THE " TO < > ACCORDINGLY
THANKS