SharkBait

Hello,

It seems I am in need of some decent error handling strategies. I've been looking into the Try..Catch..Finally part of it.

Where is the best to use this sort of handling? I'd imagine I wouldnt put it into every function I have would I?

My programs can get the occational runtime error when either the database can not be found or the connection to it has been timedout. Or if some sorta quarky problem has happened.

All I know is I am getting frustrated with runtime errors as it forces the program closed and whatever was being done in it is lost.

Any advice much appreciated

SharkBait

Iceplug

Ideally, you should first be able to know what line(s) raise your error. You should only have a handful of lines that raise an error. If you have an error that occurs in all of your functions, then you should recode and setup a proper initialization sub.
How many lines do you get errors on? You should only need to setup a Try Catch block on the lines that are known or very prone to an error.

SharkBait

Thats makes sense. So my best bet would be to use try..catch with my MySQL lookups. Since there can be times where the database is unreachable and this would definately cause a runtime error.

So Pseudo wise it would be something like:


Now I just need to find what type of errors can happen when I do something like this.

Thanx

Iceplug

If you caught the type of exception that was thrown (in the error box), you can apply it there. Otherwise, you can catch the generic exception class that catches all catchable exceptions.