ADO results set vs. BDE




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?

Thanks,

Hajo
.