Aside from bug fixes the ADO components are the same. The Delphi ADO
components are just wrappers around Microsoft ADO and that has not
changed in a long long time.
I prefer to stick to ADODataSet and ADOCommand since they are the
closest to the Microsoft ADO components, however, you will find it
easier to use ADOQuery when you migrate from BDE since TADOQuery was
designed to mimic TQuery as closely as possible. There is no reason not
to use TADOQuery.
Why are you using cached updates?
What database are you using?
Is there any reason why using a client side cursor in ADO will not give
you the same behavior that you get with cached updates?
Bill Todd (TeamB)