存储过程CREATE procedure ifexsitbikerecord
@bikeno varchar(15),
@total int output
as
set nocount on
select * from machine_parameter where bikeno =@bikeno
set @total =@@rowcount
set nocount off
GO
调用过程With Cmd
.ActiveConnection = DataConn.ConnectionString
.CommandText = "ifexsitbikerecord" '在充电车充电参数设置表中查找对应车的设置参数
.CommandType = adCmdStoredProc
.Prepared = True
End With
Set Para = Cmd.CreateParameter("@bikeno", adLongVarChar, adParamInput, 15, BikeNo)
Cmd.Parameters.Append Para
Set Para = Cmd.CreateParameter("@total", adInteger, adParamOutput)
Cmd.Parameters.Append Para
Set Rec = Cmd.ExecuteText1.Text = Cmd.Parameters("@total").ValueText1始终无显示
是语句有什么问题吗?
@bikeno varchar(15),
@total int output
as
set nocount on
select * from machine_parameter where bikeno =@bikeno
set @total =@@rowcount
set nocount off
GO
调用过程With Cmd
.ActiveConnection = DataConn.ConnectionString
.CommandText = "ifexsitbikerecord" '在充电车充电参数设置表中查找对应车的设置参数
.CommandType = adCmdStoredProc
.Prepared = True
End With
Set Para = Cmd.CreateParameter("@bikeno", adLongVarChar, adParamInput, 15, BikeNo)
Cmd.Parameters.Append Para
Set Para = Cmd.CreateParameter("@total", adInteger, adParamOutput)
Cmd.Parameters.Append Para
Set Rec = Cmd.ExecuteText1.Text = Cmd.Parameters("@total").ValueText1始终无显示
是语句有什么问题吗?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货