Re: Migrate BDE Delphi 5 to ADO Delphi 2006

Rhea Grason wrote:

I have to upgrade several apps from Delphi 5 using the bde to Delphi
2006 and ADO. I don't actually have the new version of Delphi yet so
I am changing a couple of forms to ADO in Delphi 5 right now. Are
the ADO components the same in Delphi 2006? Should I be using ADO

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.

datasets or ADO queries? I use cached updates a lot. What would be

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.

the best approach to this kind of upgrade? Thanks.

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)
.

Relevant Pages

  • Re: Delphi 8 and ado.net
    ... > different to using say ADO in Delphi? ... The Delphi ADO implementation is basically a wrapper around the Recordset ... have cursors into the database, there are no cursors in ADO.NET. ...
    (borland.public.delphi.non-technical)
  • Re: Sub Selects?
    ... > some nice Delphi DB technique to do this, or should I just build up the ... Due to the way that the ado ... lets assume that you have a list called SelectedIds ... I'd recommend against using the filtering method. ...
    (borland.public.delphi.database.ado)
  • Re: dbGO for .NET (aka ADOExpress) - dont hold your breath
    ... Mike - we're in the same boat as you. ... Delphi 8 all the ADO components are deleted - ... He told me it might not make it in until Delphi 9! ...
    (borland.public.delphi.non-technical)
  • Re: bde cachedupdates in tquery and ado
    ... ClientDataset as a Replacement for Cached Updates ... > I'm currently changing my codes to ado components from bde. ...
    (borland.public.delphi.database.ado)
  • Re: recursive sp, fmtonly, ado,
    ... This was the first thing I've checked, because I suspect Delphi. ... It's in somewhere inside ADO or OLEDB. ... >> create procedure fmttest ...
    (microsoft.public.sqlserver.programming)