I believe the entire record is included in the solution set that the CHOOSE is based on. Restricting what appears in the choice box has no effect on the size of the solution set. You can restrict the number of records in the solution set or you can project a temp table with just the information you want to work with in the CHOOSE command.
At 10:47 AM 8/18/2004 -0400, you wrote: >I restricted the lookup to a string of 35 characters and the table has only >650 records in it. I still get the same problem that I got before I made >the restriction. > >Any other ideas? I really appreciate your time > >----- Original Message ----- >From: "Albert Berry" <[EMAIL PROTECTED]> >To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> >Sent: Tuesday, August 17, 2004 5:06 PM >Subject: [RBASE-L] - Re: Pop-Up Menu > > >> It is the total character count that counts <G> >> with 1,000 students, to display the whole list, it will work if all the >records average out to about 30-32 characters. This is why you are almost at >the end of the alphabet when you run out - that's where you have hit the 32K >limit. >> >> Try restricting the width of each student returned so that the length of >each of the rows returned is 30 characters. >> >> CHOOSE ... FROM ... (LJS(Studentlastname,19) & LJS(Studentfirstname,10)) >> >> >> "Joel Solomon" <[EMAIL PROTECTED]> wrote: >> >> >Are you sure, the entire table has less than 1,000 students. >> > >> >Thanks >> >----- Original Message ----- >> >From: "Bernie Corrigan" <[EMAIL PROTECTED]> >> >To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> >> >Sent: Tuesday, August 17, 2004 3:20 PM >> >Subject: [RBASE-L] - Re: Pop-Up Menu >> > >> > >> >> Your solution set is too large. You are going to >> >> have to come up with a means to limit it. >> >> >> >> >> >> At 11:19 AM 8/17/2004 -0400, you wrote: >> >> >Here is a real head scratcher. >> >> > >> >> >I have a form with a simple pop-up menu that lists students by their >name >> >> >(last name, first name). The pop-up works perfectly. When the pop-up >> >> >window appears in the form and I enter the first few letters of the >> >students >> >> >last name, the cursor goes directly to that student. >> >> > >> >> >Now for the problem. When I enter any letter after the letter "U", the >> >> >cursor does not move to the student. For example: >> >> > >> >> >Smith >> >> >Sorento >> >> >Sutton >> >> >Sykes >> >> > >> >> >When I enter S-O the cursor goes to Sorento. When I enter S-U the >cursor >> >> >stays on Smith. This only happens for letters from U thru Z. Am I >going >> >> >crazy? >> >> > >> >> > >> >> > >> >> >Joel Solomon >> >> >Controller >> >> >Barbizon International >> >> >[EMAIL PROTECTED] >> >> > >> >> >--- 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. >> >> >================================================ >> >> > >> >> > >> >> >> > >> > >> >> >> -- >> Albert Berry >> Management Consultant >> RR2 - 1252 Ponderosa Drive >> Sparwood, BC V0B 2G2 >> Canada >> (250) 425-5806 >> (250) 425-7259 >> >> >> __________________________________________________________________ >> Switch to Netscape Internet Service. >> As low as $9.95 a month -- Sign up today at >http://isp.netscape.com/register >> >> Netscape. Just the Net You Need. >> >> New! Netscape Toolbar for Internet Explorer >> Search from anywhere on the Web and block those annoying pop-ups. >> Download now at http://channels.netscape.com/ns/search/install.jsp >> > >
