HandleBasicError

Syntax

SQL.HandleBasicError ErrNum, ErrLine, ModName, ProcName[, ErrTxt][, ErrObj]

Description

For displaying error messages during error handling in macros. Displays a TRADIUM error message dialog, also recording the error message in the error message log.

Parameter	Description
ErrNum	The number of the error message
ErrLine	The program line on which the error occurred
ModName	The name of the macro/module
ProcName	The name of the procedure
ErrTxt	Optional. Description of error. If not entered, the description will be traced using ErrNum
ErrObj	Optional. If there are multiple errors, such as when using ADODB objects, the Errors-collection object can be included here. The dialog box will then allow the user to read multiple error messages.

See Also

Example

Sub Main()
 
    On Error GoTo CatchError
 
    Dim x As Integer
    Debug.Print 10 / x   ' Devide by zero error
 
    Exit Sub
 
CatchError:
    SQL.HandleBasicError Err.Number, 1, "My Demo.bas", "Sub Main", Error$
    Resume Next
 
End Sub