Sami, Thanks for the help.
Merry Christmas and Happy New Year. Regards, Dr. Rick Brown ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 7:21 AM Subject: [RBASE-L] - Re: CHKBOX Limitations, Problem #1. > Rick - > > I think some of the problem is when you reach the expression size limit in > the variable, gtprodtype. Could you add: > > UNION SELECT 'All Records" FROM somecontroltable or even do a preliminary > select by some other sorting group so that the number of records is smaller? > > If not, then you'd have to set up a form with a scrolling region for them to > mark each of the records they want. > > Sami > > ----------------------------------------------------------------- > Sami Aaron > Software Management Specialists > 19312 W 63rd Terr > Shawnee KS 66218 > mailto:[EMAIL PROTECTED] > 913-915-1971 > > ----- Original Message ----- > From: Trinity Business Technologies > To: RBASE-L Mailing List > Sent: Thursday, December 18, 2003 3:28 AM > Subject: [RBASE-L] - CHKBOX Limitations, Problem #1. > > > I am using R:Base v6.5++ (Windows) Build 1.866xRT03. > > I have created a utility that utilizes the CHOOSE command with the CHKBOX > n parameter. > > I have a table in my database that contains 250 rows of data. One of the > fields in my database is named "prodtype" and contains unique values but is > not a Primary Key. The user is presented with a list of every value within > the specified field and is asked to select the values they want to use from > the list. Here is how I have constructed the CHOOSE command: > > CHOOSE gtprodtype FROM #VALUES FOR prodtype FROM products AT 25, 35 CHKBOX > 500 TITLE 'Select Product Types' > > When the program is run the user presses SHFT-F6 to select all the values. > A message is then displayed that tells the user that "Maximum Number Of > Checks Has Been Made". When I check the contents of the gtprodtype variable > it only contains 99 values, not 250. > > What do I need to do to allow the user to select all 250 values? > > Thanks for your assistance. > > > RB > --- 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. ================================================
