I'm trying to catch the error with following code and my code will stop
executing before getting to on error resume next. What is wrong with it?
'I'm executing a stored procedure
Set objRS = objCon.Execute(strQuery)
'I will not get to this line if there is an error like
'unique constraint in my SP
on error resume next
if Err.Number <> 0 then
I'm checking for Error <> 0 after every SQL statement in my SP and
rolling back if there is an error.
*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just ...