H
hufei
Unregistered / Unconfirmed
GUEST, unregistred user!
各位高人:我想写个分布式事务实现下列语句的事务功能,但写不出来,请指点
谢谢 qrystr:='insert into hyk(kh,xm,je,rq1,yxq1,zt,dzl,yxq2,xfds,sfcz,sfdz,sfjd,bz,username) select kh,xm,je,rq1,yxq1,zt,dzl,yxq2,xfds,sfcz,sfdz,sfjd,bz,username from OPENDATASOURCE('+chr(39)+tempstr1+chr(39)+','+chr(39)+'Data Source='+remotesrv+';User ID=hyl;Password=win2005rykj.com'+chr(39)+').gyhyk.dbo.hyk';
localADOtemp.Close;localADOtemp.SQL.Clear;
localADOtemp.SQL.Add(qrystr);
try localADOtemp.ExecSQL finally end;
谢谢 qrystr:='insert into hyk(kh,xm,je,rq1,yxq1,zt,dzl,yxq2,xfds,sfcz,sfdz,sfjd,bz,username) select kh,xm,je,rq1,yxq1,zt,dzl,yxq2,xfds,sfcz,sfdz,sfjd,bz,username from OPENDATASOURCE('+chr(39)+tempstr1+chr(39)+','+chr(39)+'Data Source='+remotesrv+';User ID=hyl;Password=win2005rykj.com'+chr(39)+').gyhyk.dbo.hyk';
localADOtemp.Close;localADOtemp.SQL.Clear;
localADOtemp.SQL.Add(qrystr);
try localADOtemp.ExecSQL finally end;