Public Function Read(ByVal sSql As String) As Recordset On Error GoTo ErrHandle
Set Read = New Recordset Read.Open sSql, DB, adOpenDynamic, adLockOptimistic Exit Function ErrHandle: MsgBox "读取数据库记录失败!" & Err.Description End Function Public Sub Excute(ByVal sSql As String) On Error GoTo ErrHandle
DB.Execute sSql
Exit SubErrHandle: MsgBox "执行数据库操作失败!" & Err.Description End Sub
On Error GoTo ErrHandle
Set Read = New Recordset
Read.Open sSql, DB, adOpenDynamic, adLockOptimistic
Exit Function
ErrHandle:
MsgBox "读取数据库记录失败!" & Err.Description
End Function
Public Sub Excute(ByVal sSql As String)
On Error GoTo ErrHandle
DB.Execute sSql
Exit SubErrHandle:
MsgBox "执行数据库操作失败!" & Err.Description
End Sub
我的意思是指定義一個全局性的變量,在程式運行期間一直捕捉Sqlserver的錯誤,如果產生錯誤則作出提示,不是等到去數據庫索取數據時才進行錯誤處理,該如何處理呢?不過還是對以上兩位高手給以的幫助深表謝意!
:XXX
-_-好像记得什么地方说过尽量不让用goto语句来者-_-