如题:存储过程
create procedure P_NNum(@PNo as CHAR(2))
AS
select * from T_Num where NNo=@PNo
GOVB代码
Public Function AddNum(Strnum As String)
Dim commd As New ADODB.Command
dim rs as new adodb.recordset
commd.ActiveConnection = cnn
commd.CommandType = adCmdStoredProc
commd.CommandText = "P_NNumUp"
commd.Parameters("@PNo") = Trim(Strnum)
set rs=commd.Execute
End Function各位大虾,请问RS可否[新增][修改][删除]等操作!
create procedure P_NNum(@PNo as CHAR(2))
AS
select * from T_Num where NNo=@PNo
GOVB代码
Public Function AddNum(Strnum As String)
Dim commd As New ADODB.Command
dim rs as new adodb.recordset
commd.ActiveConnection = cnn
commd.CommandType = adCmdStoredProc
commd.CommandText = "P_NNumUp"
commd.Parameters("@PNo") = Trim(Strnum)
set rs=commd.Execute
End Function各位大虾,请问RS可否[新增][修改][删除]等操作!
如果是新增,修改,删除,最好直接使用SQL语句
你建立的数据库连接对象
cnn.execute "select * from a" 支持执行SQL语句