Smart Error Traping

Ned · September 5th, 2003, 10:29 AM

Hi there,
Does anybody know, when an error occured how can I get error source line?

-ned

stephanel · September 5th, 2003, 12:27 PM

Hi Ned,

You can get the source line with function Erl. You will need to add number to each line that execute code.

An example of how to use the Erl

Code:

Private Sub Form_Load()
     Dim iTest As Integer

     On Error GoTo CheckError

1    If iTest = 0 Then
2      iTest = Exp(320)
     End If

     Exit Sub

CheckError:

     Debug.Print "Number: " & Err.Number
     Debug.Print "Source: " & Err.Source
     Debug.Print "Description: " & Err.Description
     Debug.Print "Line: " & Erl
End Sub

StÃ©phane Lajoie

Ned · September 7th, 2003, 05:07 AM

StÃ©phane,
This is new to me, I rerally appreciate your response.
But my application is very big - around 20,000 lines.
I don't know how many days it will take me to write line
numbers in order to implement Erl.
We are planning to migrate our application to .NET. I am
wondering if there is any easy solution in .NET then I do not
have to bother otherwise I can start working on it.

-ned

amar · September 7th, 2003, 08:05 AM

For inserting Line No ,Err Handler and Comments there is V.Good tool(Addin) avaliable at www.mztools.com
Really it is good.

Failure is not a Defeat it is just a Delay

Yehuda · September 11th, 2003, 05:01 PM

Ned,

Erl still exists in .NET. In edition .NET supports a exception based error trapping system that has the ability to give back the actual call that failed. See http://msdn.microsoft.com/library/de...exceptions.asp
for more information.

Yehuda