If you're using a class, you should use the Error method instead on ON ERROR.
>The following line gave me an error stating the 'this' can only be used in a method :
>
>ON ERROR this.adoconnectionerror()
>
>where 'this' is my ADO handling class and ADOConnectionError is the method that handles ADO errors. Even if I create a seperate class to handle the error I still have to create a property to hold the object and I'm back where I started.
>Please don't tell me I have to use an external procedure or a public variable....
>
>Also, this error would indicate that 'this' is not a pointer. Surely whatever comes after ON ERROR would evaluate to a memory address. Either ON ERROR has some weird behaviour or 'this' isn't what it appears to be...
>
>Thanks in advance..
>
>Pablo
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer