6.5++ DOES allow retcol with chkbox. Earlier versions did not GARY Winzeler <[EMAIL PROTECTED]> wrote:
>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 > > -- 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
