A comment: you do not need to CTXT() the return variable, it will be returned as text automatically.
When I have a large list such as this, I do a dialog first to grab a first few characters as a filter to reduce the size of the return set. SET VAR vChoice TEXT, vKey TEXT DIALOG "First few Characters" vChoice = 10, vKey 1 IF vKey = '[Esc]' then ..exit commands such as GOTO Stop ENDIF SET VAR vChoice = (.vChoice + '%') CHOOSE vxcid FROM #VALUES FOR + (LJS(CTXT(cname),30) & LJS(addres1,30)), + (CTXT(cid)) + FROM vwc + WHERE cactive = 0 AND spid = .vdcontid + AND cName LIKE .vChoice + AT 18, 1 CHKBOX + TITLE 'Select Company(s) to Change Sales Person' + CAPTION 'Select Multiple Companies' + LINES 19 FORMATTED GARY Winzeler <[EMAIL PROTECTED]> wrote: >I am using 6.5++ windows 1.866xRT03 - when I use the choose command with >chxbox and I have more picks than the returned variable will handle - text >limited to 1500 characters, is there any way around this?? > >here is the command: > >CHOOSE vxcid FROM #VALUES FOR + > � (LJS(CTXT(cname),30) & LJS(addres1,30)), + > � (CTXT(cid)) + > � FROM vwc + > � WHERE cactive = 0 AND spid = .vdcontid + > � AT 18, 1 �CHKBOX + > � TITLE 'Select Company(s) to Change Sales Person' + > � CAPTION 'Select Multiple Companies' + > � LINES 19 FORMATTED > > >the return column cid is and integer primary key > >Thanks > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
