Sub Main()
Dim paras As ADODB.Parameters
Dim para As ADODB.Parameter Set para = MakePara("TableName", adVarWChar, adParamInput, 50, TableName) paras.Append para <-- 此句出错, 提示对象变量或With块变量未设置 Set para = MakePara("FieldName", adVarWChar, adParamInput, 50, FieldName))
paras.Append para
...
End FunctionPublic Function MakePara(Name As String, DataType As ADODB.DataTypeEnum, Direction As ADODB.ParameterDirectionEnum, DataSize As ADO_LONGPTR, Value As Variant) As ADODB.Parameter
Dim para As New ADODB.Parameter
para.Name = Name
para.Type = DataType
para.Direction = Direction
para.Size = DataSize
para.Value = Value
Set MakePara = para
End Function
Dim paras As ADODB.Parameters
Dim para As ADODB.Parameter Set para = MakePara("TableName", adVarWChar, adParamInput, 50, TableName) paras.Append para <-- 此句出错, 提示对象变量或With块变量未设置 Set para = MakePara("FieldName", adVarWChar, adParamInput, 50, FieldName))
paras.Append para
...
End FunctionPublic Function MakePara(Name As String, DataType As ADODB.DataTypeEnum, Direction As ADODB.ParameterDirectionEnum, DataSize As ADO_LONGPTR, Value As Variant) As ADODB.Parameter
Dim para As New ADODB.Parameter
para.Name = Name
para.Type = DataType
para.Direction = Direction
para.Size = DataSize
para.Value = Value
Set MakePara = para
End Function
解决方案 »
- 关于使用XMLHTTP模拟浏览器post数据 到子frame的问题
- 求教一个关于VB的字符串问题
- 服务器上的一个SQLSERVER数据库,想在本地机上保存属于本地机的数据备份,当心服务器出问题时的数据丢失。如何不写代码直接备份,即在给服务器存记录时也同时给本地机存一份,不写同样的代码或少量写代码能实现吗?
- 请教一个关于comboBox问题
- 请教一个关于在Picture组件或者打印机上画线条的问题。
- CHECKSUM算法求解
- 关于 select 语句order by关键字的疑惑?
- 怎样让DataGrid的焦点移到最后一条记录上,并且选中第二个字段?一定送分!!
- 一个比较奇怪的问题,vb数据库
- 如何在VB中向手机发送汉字信息?
- VB用copy命令把自身复制到指定文件夹内
- 用VB做计算机图形学扫描线种子填充定义的变量出问题
Dim param As ADODB.Parameter
Dim mConn As ADODB.Connection
Dim cmd As ADODB.Command
Set cmd = New ADODB.Command
Set mConn = New Connection
mConn.Open ConnectString
cmd.ActiveConnection = mConn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "procedure1"
If MSFlexGrid1.Rows > 1 Then
For i = 1 To MSFlexGrid1.Rows - 1
Set param = cmd.CreateParameter("@code", adVarChar, adParamInput, 20, MSFlexGrid1.TextMatrix(i, 0))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("@custname", adVarChar, adParamInput, 50, MSFlexGrid1.TextMatrix(i, 1))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("@rebackmoney", adDouble, adParamInput, , Val(MSFlexGrid1.TextMatrix(i, 2)))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("@codemoney", adDouble, adParamInput, , Val(MSFlexGrid1.TextMatrix(i, 3)))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("@codedate", adVarChar, adParamInput, 50, MSFlexGrid1.TextMatrix(i, 4))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("@oppuser", adVarChar, adParamInput, 50, UserName)
cmd.Parameters.Append param
Set param = cmd.CreateParameter("@oppstate", adInteger, adParamOutput, 1, 0)
cmd.Parameters.Append param
cmd.Execute
'……
Dim paras As ADODB.Parameters但是不可以这样定义:
Dim paras As new ADODB.Parameters似乎此路不通
Dim paras As ADODB.Parameters
Dim para As ADODB.Parameter
Dim sql As String Set cmd = New ADODB.Command
With cmd
.ActiveConnection = "Provider = SQLOLEDB.1;" & _
"Persist Security Info = False;" & _
"User ID = sa;Password = 123;" & _
"Data Source = 192.168.11.218;" & _
"Initial Catalog = TEST"
.CommandType = adCmdText
.CommandText = sql
End With
Set paras = cmd.Parameters
Set para = MakePara("TableName", adVarWChar, adParamInput, 50, TableName)
paras.Append para ' --此句出错, 提示对象变量或With块变量未设置 Set para = MakePara("FieldName", adVarWChar, adParamInput, 50, TableName)
paras.Append para '......