Am I doing something wrong?, why is it bombing out at 150 characters??
Here is the variable that makes it and nothing more (one more pick makes it bomb).
vxcid = 299,511,298,322,283,532,82,488 ,65,197,429,384,492,314,288,62 2,158,509,534,79,530,290,191,1 84,205,425,624,93,100,8,335,16 4,291,552,276,106,637,198,410
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
>
>
