Larry: Try the following command:
choose vx from #VALUES for (LJS(CTXT(TransID),10) + LJS(CTXT(CustID),10) + LJS(CTXT(EmpID),20) + LJS(CTXT(TransDate),12)), TransID from invoiceheader chkbox It returns the same string as your example but it will only allows you to select 20 records.in 7.5 anyway. Javier, Javier Valencia 913-915-3137 _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Monday, June 30, 2008 4:14 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Choose command with CHKBOX n option << I actually get an R:base message telling me the Maximum Number of Choices have been made and it will not allow me to choose any more. >> I just ran this command: choose vx from #VALUES for transid from invoiceheader chkbox from the RRBYW14 database R> prompt. Through dint of tedious clicking, I was able to select all 93 records in InvoiceHeader, returning a string with 93 items and a total length of 1022 characters (the length is longer than you would expect because R:Base is padding the integers with spaces). I did not predefine vx, and R:Base selected TEXT for its type. You might want to start there and slowly add options until you figure out where the problems is. -- Larry
