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
