[RBG7-L] - RE: Memory allocation

[Jan Johansen]

I believe you are running into the 4k barrier.   1200 student and at least 40 characters in the choose definitely blows it.   Jan ----- Original Message ----- From: Joel Solomon To: RBG7-L Mailing List Sent: Monday, May 23, 2005 10:06 AM Subject: [RBG7-L] - RE: Memory allocation Bob,   This is a choose statement that I use in another part of my application that is causing the same memory allocation problem.  What do you think?  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: [EMAIL PROTECTED] To: RBG7-L Mailing List Sent: Monday, May 23, 2005 12:45 PM Subject: [RBG7-L] - RE: Memory allocation You might want to post your select statement (or what ever statement is causing the problem) section.  The only time I have ever seen something similar is when I left a ' or a ) out of a statement within a while loop etc.  When I put the code in correctly, no problems.   I too have made huge selections either by reports, select statements, browse or updates and have not had any memory errors as such when coded correctly.    I guess your PC could have a bad memory card, but probably not likely.   -Bob   -------------- Original message -------------- > 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" > 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: rbg7-l@rbase.com [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] > > >