What is your RB 65 Version/Build? ----- Original Message ----- From: "GARY Winzeler" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, October 14, 2003 9:35 PM Subject: [RBASE-L] - RE: Choose with chxbox
> The real problem is if you choose more than the 1500 then you get a program > error - RBG65.exe and completely kicked out, which unless you limit the > number in the choose makes the chxbox not useable. Why doesn't it return > an error?? > > Is there anything better for this in 7.0?? > > I guess I could use a form but it is harder to get around in a form, ie > page up - down - walk menu so on... > > > > At 02:18 PM 10/14/2003 -0500, you wrote: > >I don't think the number of listings in the Choose was the issue. The > >issue is the limitation in > >the length of the variable containing the return values which is supposed > >to be 1500 chars (I > >actually get 1834 by setting the variable to type Note before executing > >the Choose). But your point > >is well taken that some effort should be done to get the data in chunks > >instead of all at once.... > > > > > >----- Original Message ----- > >From: "Albert Berry" <[EMAIL PROTECTED]> > >To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > >Sent: Tuesday, October 14, 2003 2:04 PM > >Subject: [RBASE-L] - RE: Choose with chxbox > > > > > > > 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 > > > > > > > >
