我想在VB中输出存储过程的输出参数的值,例如
Set rs = cn.Execute("exec judge 'CG%','CGTH%','" & txtID.Text & "','" & .TextMatrix(i, 1) & "'," & Int(.TextMatrix(i, 3)) & ",'" & message & " output'")
message表示要输出的参数,但在程序执行的过程中,存储过程并没有赋值给message,不知何故,请各位大侠指点,谢啦!
Set rs = cn.Execute("exec judge 'CG%','CGTH%','" & txtID.Text & "','" & .TextMatrix(i, 1) & "'," & Int(.TextMatrix(i, 3)) & ",'" & message & " output'")
message表示要输出的参数,但在程序执行的过程中,存储过程并没有赋值给message,不知何故,请各位大侠指点,谢啦!
解决方案 »
- 问个莱鸟问题
- Form1上面有个picture,我现在可以设picture跟随鼠标移动,但是form不会跟着鼠标移动,怎么办?(附源代码)
- 谁有有关视频监控的编程类的介绍或例子?
- 用VB怎写这一段代码,在线等待!
- 如果实现ACTIVEREPORT的分页合计及总合计功能
- 请问怎么实现这种效果?
- 求助!如何关闭 list 列表上的滚动条?我不想让它显示出来
- 请问如何用代码给imagelist 加图标 谢谢解决给分!!!!!!!
- 如何将从数据库查询出来的数据加工后再传给datagrid显示出来???
- 给Data Report设计的每一张报表使用指定的打印机和打印纸?
- Excel VBA程序中如何获取当前Excel文件所在的路徑啊,急,11点结贴
- access数据库中表的名称问题
不知为什么,请大侠指教,谢啦
private sub Command1_click()
If MsgForQuestion("您真的要对当前采购单进行结案吗?") = False Then Exit Sub
Dim cm As New ADODB.Command, par As ADODB.Parameter
On Error GoTo ErrHandle
cn.BeginTrans
cm.ActiveConnection = cn
cm.CommandType = adCmdStoredProc
cm.CommandText = "CGOk"
Set par = cm.CreateParameter("P1", adBSTR, adParamInput, Len(Me.TxtQgdh.Text), Me.TxtQgdh.Text)
cm.Parameters.Append par
Set par = cm.CreateParameter("P2", adBSTR, adParamOutput, 50)
cm.Parameters.Append par
cm.Execute
cn.CommitTrans
GoTo ExitHandle
ErrHandle:
cn.RollbackTrans
ExitHandle:
MsgForInfo cm.Parameters("P2").Value
end sub
-----------------------存储过程----------------------------------
CREATE proc CGOk @cgm_cgdh varchar(10),@ok Varchar(50) Output
as
Declare @zt Char(1),@cgm_sumje numeric(18, 2),
@fkm_sumfkje numeric(18,2)select @zt=cgm_zt from cgm_mstr where cgm_cgdh=@cgm_cgdh
if @zt='1'
Begin
set @ok='此需求单尚未结转,请先结转再行结案!'
Raiserror('此需求单尚未结转,请先结转再行结案!',16,-1)
Return
Endif @zt='3'
Begin
set @ok='此采购单已取消,不能结案!'
Raiserror('此采购单已取消,不能结案!',16,-1)
Return
Endif @zt='4'
Begin
set @ok='此采购单已结案,不能结案!'
Raiserror('此采购单已结案,不能结案!',16,-1)
Return
Endselect @cgm_sumje = cgm_sumje from cgm_mstr where cgm_cgdh=@cgm_cgdh
select @fkm_sumfkje= sum(fkd_fkje) from fkm_mstr
inner join fkd_det on fkm_fkdh=fkd_fkdh
where fkm_cgdh=@cgm_cgdhif @fkm_sumfkje < @cgm_sumje
Begin
set @ok='此采购单付款尚未完毕,不能结案!'
Raiserror('此采购单付款尚未完毕,不能结案!',16,-1)
Return
Endupdate cgm_mstr set cgm_zt='4' where cgm_cgdh=@cgm_cgdh
update fkm_mstr set fkm_zt='2' where fkm_cgdh=@cgm_cgdh
update fkd_det set fkd_zt='2' from fkd_det inner join fkm_mstr on fkd_fkdh=fkm_fkdh where fkm_cgdh=@cgm_cgdhSet @ok='恭喜、恭喜,结案成功了!(good)'