ADO如何更新多个join表数据
用ADODataSet查询多表JOIN的数据,不用DBNavigator控件如何将多条修改记录更新回各自数据表?ADODataSet的CommandText值为:
select a.yqdh,a.ybbh,a.cdrq,a.xmdh,b.xmmc,c.zhdh,c.zhmc,a.xmcdz,
a.gdbj from lis_xmcdz a left join xt_xmb b on a.yqdh=b.yqdh
and a.xmdh=b.xmdh left join xt_xmzh c on a.yqdh=c.yqdh and a.xmdh=c.xmdh where a.yqdh=:yqdh and a.ybbh=:ybbh
and a.cdrq=:cdrq