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.
1) You definitely have to migrate from BDE to DbExpress. BDE is an obsolete and deprecated technology.
You can read these articles
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.