I am making a simple query on an amount of data that I think should not
fire a GPF:
 "select distinct d1.name from invoices d, names d1 where
d.idnumber=d1.numberid".
Table NAME  has 2,000 recds (just a name and corresponding id number).
Everything works OK until I have more than 89,000 records in the INVOICES
table. After that neither BDE 16 nor BDE 32 can handle the query,
aborting program's execution with an "access violation" error, or a GPF
under Win3.11.
I thought about splitting the huge table, but I am realizing that it
seems to be a BDE bug, or it simply cannot cope with such an amount of
data, invading system memory area? That's happening even on 32-bit
Database Explorer for Delphi 2.0 under NT 4.0!!!
Thanks for the concern
Edric

Edric:

What are you using for a database?

-Dave

In article <MPG.db4d06a3c3b4e9f989...@news.unisys.com.br>,
efi...@unisys.com.br says...

Dave,
I am working with a TQuery component over 2 local Paradox 4.0 tables
(names.db and invoices.db). Everything goes ok until I get the invoices
records above 85,000. Then there is the system area violation.
Thank you
Edric

I had a similar situation with a 22000 record table.  I increased the stack
size and recompiled and cleared up the problem so far.

Edric Filho <efi...@unisys.com.br> wrote in article
<MPG.db4d06a3c3b4e9f989...@news.unisys.com.br>...