Dim cm As New Command ' ¶¨ÒåÃüÁî¶ÔÏóDim inparam As Parameter
Dim outparam As Parameter
With cm
Set .ActiveConnection = gADO
.CommandText = "SP_GetNextID"
.CommandType = adCmdStoredProc
Set inparam = .CreateParameter("@Table_No", adInteger, adParamInput, , intNo)
Set outparam = .CreateParameter("@id", adInteger, adParamOutput) .Parameters.Append inparam
.Parameters.Append outparam
.Execute
End With
GetStoreProNextID = cm.Parameters.item(1).ValueSet cm = Nothing
Dim outparam As Parameter
With cm
Set .ActiveConnection = gADO
.CommandText = "SP_GetNextID"
.CommandType = adCmdStoredProc
Set inparam = .CreateParameter("@Table_No", adInteger, adParamInput, , intNo)
Set outparam = .CreateParameter("@id", adInteger, adParamOutput) .Parameters.Append inparam
.Parameters.Append outparam
.Execute
End With
GetStoreProNextID = cm.Parameters.item(1).ValueSet cm = Nothing
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货