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 >
