connection有返回码
用withevents定义Connection并通过willexecute事件检测
用withevents定义Connection并通过willexecute事件检测
解决方案 »
- 关于时间控件的问题
- execl问题,清高手们帮帮忙!急啊!高分
- VBA.VAL()
- 请教vb向word模版表格插入数据的问题,模版中表格原有1行,但要插入的记录行数有几十条,如何实现每插入一条后,word中自动生成下一空行
- 我的一个程序一直实现不了功能,帮我看一下吧!
- Worksheet(1).Range("A1").CopyFromRecordset方法调用失败,提示不支持的接口。!!!
- 请问用API函数NetMessageBufferSend (NETAPI32.DLL) 局域网广播消息`WIN200成功而WIN98失败原因何在?如何解决?
- activereport如何被反复调用?
- 智能数据挖掘引擎-全新的数据挖掘工具,轻巧,强大,脚本化_
- 说者有分!
- 设计书问题:
- 打印问题:怎么样控制卷纸长度?
ByVal pError As ADODB.Error, _
adStatus As ADODB.EventStatusEnum, _
ByVal pCommand As ADODB.Command, _
ByVal pRecordset As ADODB.Recordset, _
ByVal pConnection As ADODB.Connection)
If adStatus = adStatusErrorsOccurred Then
MsgBox pError.Description
Else
MsgBox "exec success"
End If
End SubPrivate Sub Command2_Click()
Set cases = CreateObject("ADODB.Connection")
cases.Open ("testdb1")
Dim num As Integer
exsql = "delete from Table1 where ID>0"
On Error GoTo errl
cases.Execute exsql, num
Text2.Text = num
Exit Sub
errl:
MsgBox Err.Description
Exit SubEnd Sub每次执行与ADO有关的操作时,所有provider errors都被加入connection的Errors属性,您也可以由此获得错误信息。修改on error的处理代码如下:
errl:
For Each Err In cases.Errors
strError = "Error #" & Err.Number & vbCr & _
" " & Err.Description & vbCr & _
" (Source: " & Err.Source & ")" & vbCr & _
" (SQL State: " & Err.SQLState & ")" & vbCr & _
" (NativeError: " & Err.NativeError & ")" & vbCr
If Err.HelpFile = "" Then
strError = strError & " No Help file available"
Else
strError = strError & _
" (HelpFile: " & Err.HelpFile & ")" & vbCr & _
" (HelpContext: " & Err.HelpContext & ")" & _
vbCr & vbCr
End If
Debug.Print strError
Next
Exit Sub详细信息请参考:
Execute Method (ADO Connection)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthcnnexecute.aspExecuteComplete Event
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdevtexecutecomplete.aspOn Error Statement
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vastmonerror.aspErrors Collection
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdcolerrors.aspDescription, HelpContext, HelpFile, NativeError, Number, Source, and SQLState Properties Example (VB)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprodescriptionx.asp
- 微软全球技术中心 VB技术支持
本贴子以“现状”提供且没有任何担保,同时也没有授予任何权利。具体事项可参见使用条款
(http://support.microsoft.com/directory/worldwide/zh-cn/community/terms_chs.asp)。
为了为您创建更好的讨论环境,请参加我们的用户满意度调查
(http://support.microsoft.com/directory/worldwide/zh-cn/community/survey.asp?key=(S,49854782))。