Dave, The indexes are OK and the form is not corrupt. In fact, I am having the same problem with the following choose statement. I set up the choose command this way so the columns in the choose box are uniform.
CHOOSE vchoice FROM #VALUES FOR ((LJS(Stu_Lname,20)) + (LJS(Stu_Fname,20)) + (Stu_Location)) ,Stu_Number FROM StudentMaster ORDER BY Stu_Identify WHERE Stu_status = 'Student' CAPTION 'Choose Student' LINES 10 FORMATTED Joel ----- Original Message ----- From: "David M. Blocker" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, May 23, 2005 12:57 PM Subject: [RBG7-L] - RE: Memory allocation > Try rebuilding the indexes > > 1. Backup the database > 1. DISCONNECT > 2. Backup the database > 3. SET MULTI OFF > 4. CONNECT database > 5. PACK KEYS > > If that doesn't help, consider the possibility that the form is corrupted. > Try creating a new one with JUST that lookup expression - does it work? > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 > ----- Original Message ----- > From: "Joel Solomon" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Monday, May 23, 2005 12:29 PM > Subject: [RBG7-L] - RE: Memory allocation > > > > Paula, > > > > Yes they are. > > Any other ideas of where I might look for this problem? > > > > Thanks > > Joel > > ----- Original Message ----- > > From: "Paula Stuart" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[email protected]> > > Sent: Monday, May 23, 2005 11:57 AM > > Subject: [RBG7-L] - RE: Memory allocation > > > > > > > Joel, > > > > > > I've got similar selections running in forms against a database > > > of 300,000 records using XP Pro with 512 MB memory with no problems. > > > Are the lookup columns indexed? > > > > > > Paula > > > > > > -----Original Message----- > > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Joel > > > Solomon > > > Sent: Monday, May 23, 2005 11:46 AM > > > To: RBG7-L Mailing List > > > Subject: [RBG7-L] - Memory allocation > > > > > > > > > Good Morning, > > > > > > I would like to know if anyone has run into this problem. I get an > > > error in my form lookup that states that I do not have enough memory to > > > allocate to the lookup function. I have only 1,200 records and I am > > > using a multi-column lookup using 3 text columns. My computer has 512 > > > MB of memory and I am running Windows XP. When I change the > > > mulit-column lookup to 2 text columns, the error goes away. > > > > > > Short of increasing my memory, what else can I do? I find it quite > > > strange that 1,200 records would cause this kind of problem. > > > > > > Thanks > > > Joel Solomon > > > V.P. Finance > > > Barbizon International > > > [EMAIL PROTECTED] > > > > > > > >
