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
