Joel When all else fails, I try something like this:
CREATE TEMP Table ChooseBox (StudentFullName, TEXT 30) INSERT INTO ChooseBox SELECT (LJS(Studentlastname,19) & LJS(Studentfirstname,10)) FROM tablename Then do CHOOSE .. FROM ChooseBox.... David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Joel Solomon" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, August 18, 2004 10:47 AM Subject: [RBASE-L] - Re: Pop-Up Menu > 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 > > > >
