Re: ADO results set vs. BDE


"hajo" <hajospuunup@xxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:4811bb9c$1@xxxxxxxxxxxxxxxxxxxxxxxxx

Hi everyone,

I have a legacy application built in Delphi 7 that uses the BDE for
database access, and we're thinking of changing over to ADO.

I've noticed that, when opening a query, TADOQuery seems to always fetch
all the results, whereas the BDE TQuery component will only fetch a few at
a time.

Can TADOQuery be made to behave like the BDE TQuery component and only
fetch a few records at a time, or can it only fetch all the results?
You can achieve something like that with ServerSide cursors, for details see
TADODataSet.CursorLocation. Also it is not recommended to use them in GUI
due to performance considerations and numerous behavior restrictions.


.