BorlandTalk.com

Rowman · Guest

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

Rowman · Guest

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.

Rowman · Guest

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.

Alan · Guest

Some of my customers are getting this error message but I'm not. I didn't
have large queries. I wonder what is going on. I've been using the BDE for
10 years and this error message starting to show up on new computers.

"Rowman" <RowanPillay (AT) gmail (DOT) com> wrote in message
news:1173086814.115180.109300 (AT) 64g2000cwx (DOT) googlegroups.com...