为何下面的代码执行的结果还是成功,且数据库还在事务中没回滚?
try
ADOConnection1.Execute('EXEC mytest');
showmessage('成功!');
except
showmessage('失败');
end;存储过程mytest如下:
mytest
as
BEGIN TRAN tranmytest
update table1
set myid = 1 SET @ErrorMsg = '出错!!'
GOTO Error
COMMIT TRAN tranmytestRETURNError:
RaisError 50001 @ErrorMsg
RollBack TRAN tranmytest
RETURN
try
ADOConnection1.Execute('EXEC mytest');
showmessage('成功!');
except
showmessage('失败');
end;存储过程mytest如下:
mytest
as
BEGIN TRAN tranmytest
update table1
set myid = 1 SET @ErrorMsg = '出错!!'
GOTO Error
COMMIT TRAN tranmytestRETURNError:
RaisError 50001 @ErrorMsg
RollBack TRAN tranmytest
RETURN
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货