Jump to content

Error Trapping

Recommended Posts

I have the code:

$FuncDate = StringRight($FuncDate,4)
    $oRec.Open("SELECT TOP 1 CallRecord_AlarmNumber,CallRecord_Date FROM CallRecord WHERE DATEPART('YYYY',CallRecord_Date)=" & $FuncDate & " ORDER BY CallRecord_Date DESC", $oADO)
    $LastCall = StringLeft($oRec("CallRecord_Date").Value,4)
    If $FuncDate = $LastCall Then
        $ToReturn = $oRec("CallRecord_AlarmNumber").value + 1
        $ToReturn = 1

Which I need to do some error trapping on. Right now if $FuncDate is greater than what is found the the database the code crashes, on the third line. I need to check for that error and set a special condition for it. How do I do this?

Thanks in Advance!

Edited by Grax
Link to comment
Share on other sites

Error handling is covered in the help file-

Error handling is implemented in the same way as a normal COM Event, using ObjEvent() and a user defined COM Event Function. The only difference is the usage of the fixed string "AutoIt.Error" as the name of the object.

An example:

$oMyError = ObjEvent("AutoIt.Error","MyErrFunc") ; Install a custom error handler 

; Performing a deliberate failure here (object does not exist)
$oIE = ObjCreate("InternetExplorer.Application")
$oIE.visible = 1
if @error then Msgbox(0,"","the previous line got an error.")


; This is my custom error handler 
Func MyErrFunc() 
   Msgbox(0,"","We intercepted a COM Error !" & @CRLF & _
                "Number is: " & $HexNumber & @CRLF & _
                "Windescription is: " & $oMyError.windescription ) 

   SetError(1) ; something to check for when this function returns 
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...