In using a BDE TQuery object, I've noticed that Delphi seems to clamp the
maximum size of a result set.  The query:

SELECT C1, C2, C3, C4, C5 FROM T1

should yield close to 7M rows, when viewed using Microsoft Query Analyzer,
but when run under BDE, it returns slightly more than 6M rows.  If I modify
the query to return fewer columns per row:

SELECT C1 FROM T1

 the BDE returns more rows.

If I use ADO to perform the same query, the results are accurate.  I'm
contemplating changing the thing over to ADO, but that would involve
altering 18 units... probably the rest of today and tomorrow.  Before
starting on that surgery, I have the
obvious question:  Is there a BDE setting somewhere which describes the size
of the result set?  Can I alter this to make that unlimited?

Thanks in advance for any help anyone might provide on this subject.
Gary Johnson

I would highly recommend making the switch to ADO. You will find it much
easier to work and also faster (in my opinion). The BDE is not supported
by Borland and the DB Lib (which the BDE uses) is not supported by either.
If it will take you today and tomorrow or even all of next week it would
be a good move.

Ross