Also, there is something goofy going on with Choose. The 6.5++ Dos version doesn't have a 1500 char limit (I just did a test that produced a 3600 char string that was held in a variable of type Text), so something happened between versions for sure. When I use Choose in windows without a value after the ChkBox parameter, and use [shift]f6, I get the maximum number of items has been selected message and counting those items reveals 98 items selected instead of every item and the length of the string of the items in the Choose display is 1834 and the length of the string in the return value is 481. If no return value is specified, then the length of the string returned in the Choose is the length of the items selected, which is 1834.
For whatever it's worth, you are stuck with this in 6.5 as there will be no further fixes to my knowledge. Some experimenting with the Choose in 7.0 has revealed some problems there as well that I have reported as Bugs to RDCC. ----- 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 > > > > > > > >
