Equivalent to TUpdateSQL in Delphi 2010 dbExpress?

Question

I am planning to migrate a Delphi 6 BDE application to Delphi 2010...

• First of all, do I have to move away from BDE? (I will but I prefer to do this in stages if possible)

• Second, is dbExpress the best choice? (I am using MS SQL)

• Lastly, is there an equivalent of TUpdateSQL in dbExpress? (or anything else)

I have a lot of codes updating readonly query from within a grid (using TUpdateSQL and ApplyUpdate).

Please help~~~

Thanks a lot.

Answer 1

1) You definitely have to migrate from BDE to DbExpress. BDE is an obsolete and deprecated technology.

You can read these articles

• Migrating BDE Applications to dbExpress
• Migrating Data from TDataSet to SQL DBMS

2) DbExpress is a better alternative than BDE to communicate with sql server, however I prefer ADO because is native for SQL Server.

3) dbExpress has no component similar to TUpdateSQL, however Luxene have a TDBXUpdateSQL wich is part from dbExpress eXtension components.

You can check also InstantBDExpress (is a component library that enables seamless migration of old BDE applications to the dbExpress technology) from ETHEA

Bye.