I must add, that to return 4k of data from a CHOOSE, the return variable must be of type NOTE. As Ken pointed out, TEXT will hold only 1500 chars or about 1.48k of data. If your string length of 16 items were about 80 chars each, and your return datatype were of TYPE TEXT, this would explain the number of items returned.
----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Sunday, June 29, 2008 7:41 AM Subject: [RBASE-L] - Re: Choose command with CHKBOX n option > In any event the total length of the Return value from a CHOOSE cannot > approximately exceed 4k in length. > > Just what is the length of the data in WorkOrder#? (not the field length, > but the length of the data) > > > > > > ----- Original Message ----- > From: "Scott Whitish" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Sunday, June 29, 2008 12:15 AM > Subject: [RBASE-L] - Re: Choose command with CHKBOX n option > > > Thanks for the response Ken, > I have defined vWorkOrders as text 500 and as NOTE with the same results. > Scott > > --- On Sat, 6/28/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Re: Choose command with CHKBOX n option > To: "RBASE-L Mailing List" <[email protected]> > Date: Saturday, June 28, 2008, 11:26 PM > > > > Scott, > > I tried the choose command with the latest release. I was able to select more > than 16. Is vWorkOrders defined in such a way the variable cannot hold all > that is selected? Text should default to 1500. > > Regards, Ken > > ----- Original Message ----- > From: Scott Whitish > Date: Saturday, June 28, 2008 9:08 pm > Subject: [RBASE-L] - Choose command with CHKBOX n option > To: [email protected] (RBASE-L Mailing List) > >> I am using the following command in an eep launched on entry >> into a form field. The vHospitalID is choosen in the previous >> form field. I have tried defining vWorkOrdes as a large 250 >> Character Text field and as a NOTE field, with the same results. >> The number following the CHKBOX is supposed to determine how >> many choices the user can check from the list. However no matter >> what I set it to in the command only allows 16 items to be >> checked. Is the a known bug in the command. I have tried it in >> both 7.5 and 7.6. The way this command is written you should be >> able to choose up to a hundred items according to the documentation. >> >> choose vWorkOrders + >> from #values for + >> (WOPrefix & Ctxt(WorkOrder#)& ' ' & ctxt(ServiceDate) & >> ctxt(TotalAmount)),+ WorkOrder# from WOHeader where HospitalID = >> .vHospitalID + >> order by PO#,workOrder# Chkbox 100 + >> title 'Choose InSite Work Orders to Assign' Caption 'Assing >> Sales Order#s' lines 25 >> >> Any thoughts would be appreciated. >> Scott Whitish >> >> >> > > >
