sqlserver 2000
有存储过程:proc_copy
现在pb里调用代码如下：
- C# code
string ls_procls_proc = 'proc_copyerp'execute immediate :ls_proc_copy using sqlca2;sqlca2.autocommit = truemessagebox('',sqlca2.sqlerrtext)if sqlca2.sqlcode <> 0 then rollback; return -1;end if消息框弹出内容为空，没有执行到，怎么样才能执行到？
------解决方案--------------------
sqlca.autocommit = true
declare report_gethours procedure for dbo.report_gethours_sp @sdate=:indate,@edate=:ldt_today,@hours=:li_hours output using sqlca;
execute report_gethours;
fetch report_gethours into :li_hours;
close report_gethours;
sqlca.autocommit = false
------解决方案--------------------
- C# code
DECLARE pro1 PROCEDURE FOR proc_copyerpUSING sqlca2 ;messagebox('',sqlca2.sqlerrtext)sqlca2.autocommit = trueEXECUTE pro1;if sqlca2.sqlcode <> 0 then rollback; return -1;end if