Re: ADO results set vs. BDE


"Vitali Kalinin" <vitkalinin@xxxxxxxxx> wrote:

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

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.



Thanks Vitali. Part of our application uses a TDBGrid to display search results. You say that Server side cursors are not recommended for GUI use - for the TDBGrid, should we just accept that we have to use a client side cursor and fetch all results, or is there anything else we could do?


.