Vishal Monpara’s Blog

Description:

I was executing a stored proc which would halt its execution using RAISERROR. When I tried to run the stored proc in Query Analyzer it worked fine and gave me error but in VBA it couldn’t halt the execution and continued to the next statement. Read more…

I had an application in which I had a code like

Dim qdf as QueryDef
qdf = new QueryDef("Query")qdf.execute

The query was not running because of error but the application was not breaking at the time of error generation. To force the application to break/throw exception write the statement like

qdf.execute dbfailOnError

and by this way we can catch all errors.