Hi All,

I'm using D5, MS SQL Server 2000. I'm developing my application using ADO
and Midas Component. How can I update record into a join query, as because
ADO has no TUpdateSQL Component and ADO Query don't have any OnUpdateRecord
event.

TIA.

Nayan Ghosh

ADO supports updatable Joins.  You will find most of the Joins you create with
MSSQL will be updatable.  You may want to look at the TbetterAdoDataset.
This TadoDataset descendant has several properties and methods that make
updating Joins easier that TadoDataset.
http://web.orbitel.bg/vassil/
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Hi
one more thing you can do is use stored procedures
open your dataset in batch update mode and set connection to Nil, then in
the before post and before delete events call your SP to preforme the action
for you

news:3d817185@newsgroups.borland.com...