[RBASE-L] - Re: Choose with chxbox

[GARY Winzeler]

Your example made me look closer at what was different in my command and 
the difference is that I used the   , retcol   and in looking at the 
command the retcol can not not be used with the chkbox.

So that appears to be the problem retcol and chkbox don't work together - <g>

Oh well on to trying something different.

Thanks

At 12:00 PM 10/15/2003 -0400, you wrote:
At 11:28 AM 10/14/2003 -0700, you 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??
Gary;

Using the following command against the ConComp database, I had the result 
of a variable,
v1, with a length of 4033 characters:

APPEND Customer TO Customer  --This created a table with 56 records

SET VAR v1 NOTE = NULL  --This gives me more room than the TEXT variable

CHOOSE v1 FROM #VALUES FOR ((CTXT(Custid))&Company&Custaddress&Custcity& +
Custstate&(CTXT(Custzip))&Custphone&(CTXT(Modlevel))) FROM Customer CHKBOX
SET VAR v2 = (SLEN(.v1))

SHOW VAR v2  --This shows the final result is 4033 characters long

If you are in a position of exceeding the 4096 character limitation of a 
NOTE variable, then
you need to rethink the logic and use a return column that is more concise 
or limit the
CHOOSE with a numeric limitation to the CHKBOX option.

Best Regards,

Mike