| View previous topic :: View next topic |
| Author |
Message |
Rowman
Guest
|
 Posted: Wed Feb 28, 2007 9:11 am Post subject: Insufficient memory to perform the operation |
 |
|
In the code I attempt to open a TQuery. However the database is large
and the where clause ends up with about almost 700 fields.
Now under most circumstances the program works fine. But when the
database large, the program crashes with an error insufficient memory
to perform the operation (the open TQuery method). After the error
occurs Upon exit of the program a few exceptions is then
thrown.......Access Violation (something about NTDLL.DLL).
Now I've tried to increase the shared memory allocation within the
BDE
administrator. This seems to only delay the problem. I have made sure
to change not only the config file but the registry file by selecting
Windows 95/NT only.
Can anyone help me with regards to my problem.
Thanx |
|
| Back to top |
|
 |
Rowman
Guest
|
| Posted: Wed Feb 28, 2007 5:28 pm Post subject: Re: Insufficient memory to perform the operation |
|
|
Another strange point that I forgot to mention is that the program
works fine when run in debug mode. Whenever run from the exe file
outside of the IDE the program crashes. How come it does not crash
when run in debug mode? I think this is strange. |
|
| Back to top |
|
|
Rowman
Guest
|
| Posted: Mon Mar 05, 2007 3:24 pm Post subject: Re: Insufficient memory to perform the operation |
|
|
I eventually just splitted the large query into smaller queries and
manually added the values etc. This is probabl inefficient but at
least I dont get the memory problem anymore.
It seems like it is a BDE problem, when handling large queries. Maybe
some sort of memory leak. |
|
| Back to top |
|
|
Brian Bushay TeamB
Guest
|
| Posted: Fri Mar 09, 2007 8:32 am Post subject: Re: Insufficient memory to perform the operation |
|
|
| Quote: | I eventually just splitted the large query into smaller queries and
manually added the values etc. This is probabl inefficient but at
least I dont get the memory problem anymore.
It seems like it is a BDE problem, when handling large queries. Maybe
some sort of memory leak.
|
This message can come up if there is insufficient space on the drive where your
private directory is located. Also if the table being queried is corrupt.
--
Brian Bushay (TeamB)
Bbushay (AT) NMPLS (DOT) com |
|
| Back to top |
|
|
Rowman
Guest
|
| Posted: Mon Mar 12, 2007 1:45 pm Post subject: Re: Insufficient memory to perform the operation |
|
|
On Mar 9, 4:32 am, Brian Bushay TeamB <BBus...@Nmpls.com> wrote:
| Quote: | I eventually just splitted the large query into smaller queries and
manually added the values etc. This is probabl inefficient but at
least I dont get the memory problem anymore.
It seems like it is a BDE problem, when handling large queries. Maybe
some sort of memory leak.
This message can come up if there is insufficient space on the drive where your
private directory is located. Also if the table being queried is corrupt.
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com
|
Thanks for your reply, I have enough space on the drive so that rules
out your first point. Could be the second point about the table. But
I'm still skeptical about that. It is working fine and even better now
that I split the query up into smaller bits.
Thanx alot for you reply though |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
