Multi-table update using ADO
Posted on 2008-10-09
I'm converting an old application to ADO from BDE and need some help.
A BDEClientdataset has been used to call a stored procedure (via commandtext) to return multi-table data to the screen. The data on-screen is edited in a DB-Aware manner and then, in the OnBeforeUpdateRecord , the data is stored away via another stored procedure and the dataset marked as applied. This all worked fine, but now I need it as ADO.
Just as a test, I added a TADOStoredProc, setting this to the procedure that returns the data and connected it all up. This works fine, returning the data to the screen. I had coded nothing else, but it allowed me to edit some of the fields in the dataset and then post them and it updates the DB.
I didn't expect to be able to edit the dataset let alone it actually updating the DB.
However I need to be able to update all fields as post them to the DB via one means or another. If anyone can help with this that would be great.
N.B. working with SQL Server 2000 & Delphi 6 :-E