Public Function ExecuteSQL(ByVal sql As String) As Adodb.Recordset
' 执行SQL语句,返回相应的记录集函数
Dim rst As Adodb.Recordset
Set adocon = New Adodb.Connection
adocon.ConnectionString = connstring
adocon.Open
Dim stokens() As String
' On Error GoTo executesql_error
stokens = Split(sql)
If InStr("INSER,DELETE,UPDATE", UCase(stokens(0))) Then
adocon.Execute sql
Else
Set rst = New Adodb.Recordset
rst.Open Trim(sql), adocon, adOpenKeyset, adLockOptimistic
Set ExecuteSQL = rst
End If
'executesql_exit:
' Set rst = Nothing
' Set adocon = Nothing
' Exit Function
'executesql_error:
' Resume executesql_exit
End Function请问各位这段调用程序哪里错了?我运行过,在把跳转错误程序屏蔽后,错误指示"rst.Open Trim(sql), adocon, adOpenKeyset, adLockOptimistic" 这句,若不把错误跳转错误程序屏蔽,那它就返回Nothing了.各位可不可以告诉我怎样改??????????????
' 执行SQL语句,返回相应的记录集函数
Dim rst As Adodb.Recordset
Set adocon = New Adodb.Connection
adocon.ConnectionString = connstring
adocon.Open
Dim stokens() As String
' On Error GoTo executesql_error
stokens = Split(sql)
If InStr("INSER,DELETE,UPDATE", UCase(stokens(0))) Then
adocon.Execute sql
Else
Set rst = New Adodb.Recordset
rst.Open Trim(sql), adocon, adOpenKeyset, adLockOptimistic
Set ExecuteSQL = rst
End If
'executesql_exit:
' Set rst = Nothing
' Set adocon = Nothing
' Exit Function
'executesql_error:
' Resume executesql_exit
End Function请问各位这段调用程序哪里错了?我运行过,在把跳转错误程序屏蔽后,错误指示"rst.Open Trim(sql), adocon, adOpenKeyset, adLockOptimistic" 这句,若不把错误跳转错误程序屏蔽,那它就返回Nothing了.各位可不可以告诉我怎样改??????????????
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货