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 > > > --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
