[RBG7-L] - RE: Memory allocation

[ttc . inc]

Joel,

  I do not know if it is a typo, but your parenthesis are not balanced.

You have 5 "(" and 6 ")"!   This will cause a problem.

 

-Bob

 

-------------- Original message --------------

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]
> >
>