我是通过函数执行SQL语句的,如果SQL语句里有distinct就会出错,请高手帮忙看一下,函数如下:Public Function ExecuteSQL(ByVal SQL As String, MsgString As String) As ADODB.Recordset
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim sTokens() As String
On Error GoTo ExecuteSQL_Error
sTokens = Split(SQL)
Set cnn = New ADODB.Connection
cnn.Open ConnectString
If InStr("INSERT,DELETE,UPDATE", UCase(sTokens(0))) Then
cnn.Execute SQL
MsgString = sTokens(0) & "query sucessful"
Else
Set rst = New ADODB.Recordset
rst.Open Trim(SQL), cnn, adOpenKeyset, adLockOptimistic, adCmdText
Set ExecuteSQL = rst
MsgString = "查询到" & rst.RecordCount & "条记录"
End If
ExecuteSQL_Exit:
Set rst = Nothing
Set cnn = Nothing
Exit Function
ExecuteSQL_Error:
MsgString = "查询错误:" & Err.Description
Resume ExecuteSQL_Exit
End FunctionPublic Function ConnectString() As String
ConnectString = "Provider=SQLOLEDB.1;Password=410403;Persist Security Info=True;" & _
"User ID=sa;Initial Catalog=data;Data Source=EWAYXT"
End Function
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim sTokens() As String
On Error GoTo ExecuteSQL_Error
sTokens = Split(SQL)
Set cnn = New ADODB.Connection
cnn.Open ConnectString
If InStr("INSERT,DELETE,UPDATE", UCase(sTokens(0))) Then
cnn.Execute SQL
MsgString = sTokens(0) & "query sucessful"
Else
Set rst = New ADODB.Recordset
rst.Open Trim(SQL), cnn, adOpenKeyset, adLockOptimistic, adCmdText
Set ExecuteSQL = rst
MsgString = "查询到" & rst.RecordCount & "条记录"
End If
ExecuteSQL_Exit:
Set rst = Nothing
Set cnn = Nothing
Exit Function
ExecuteSQL_Error:
MsgString = "查询错误:" & Err.Description
Resume ExecuteSQL_Exit
End FunctionPublic Function ConnectString() As String
ConnectString = "Provider=SQLOLEDB.1;Password=410403;Persist Security Info=True;" & _
"User ID=sa;Initial Catalog=data;Data Source=EWAYXT"
End Function
解决方案 »
- 请问怎么使用VB为程序换脸
- 如何获得另一前台窗口的句柄并对它发送一个回车事件?
- 请问如何获得一个文件的状态,如是否被其它程序运行?
- 自定义控件的属性为什么不能保存?
- 关于游戏方面的东西!
- 至少一个参数没有被指定值。怎么老出这样的报错呀,尤其是在update...set语句中!!
- 有没有用VB描述的数据结构和算法方面的书?书名,作者,下载地址(如果有的话)谢谢!!另外,还请高手推荐几本VB方面的好书,谢谢!!!
- 如何做到在程序退出时提示保存?
- end or unload?
- 用过picture控件组的请进!
- 请教,觉得是怪问题:建了一个usercontrol,在上面加了picturebox,其中放了一张gif的透明图片,设置右键菜单,但预览时有问题
- 有关ADODB
你是以什么分割字符串的?估计这里错了/另外你用F8跟踪一下,。看看哪里错了