Forcing ignoring errors from ADODB to Excel VBA -

-

i don't know if possible, figured i'd ask.

is there equivalent on error goto next adodb connections in excel vba?

i have stored procedure i'm calling using adodb.command object. problem is, if 1 statement in stored procedure throws error, entire process gets shut down. yes, that's appropriate in cases, in case, it's not big deal, i'd continue executing rest of stored procedure anyway.

on error goto 0 shows sql error message , gives options "end" or "debug".

on error resume next skips sql error message, silently cancels sql command , moves next vba statement.

any ideas?

edit: i've had request code. i'm not sure much, here:

on error goto 0  serverconnection.open "provider=msdasql.1;persist security info=true;extended properties="driver=sql native client;trusted_connection=yes;server=dbserver;database=database";"  dim sqlcommand adodb.command set sqlcommand = new adodb.command  sqlcommand     .activeconnection = serverconnection     .commandtext = "exec cachetables @cachetabletype1=true"     .commandtype = adcmdtext     .execute end  serverconnection.close  set sqlcommand = nothing set serverconnection = nothing

i don't control stored procedure, unfortunately, reason it's throwing errors person wrote used raiserror statements tell user execution to. fine in sql server, understands "priority" flag , hence continues executing, vba appears consider errors same importance.

because processing of stored procedure taking place on db server, have have kind of error handling inside stored procedure. example try/catch block in tsql if using sql server: 

begin try      { sql_statement | statement_block } end try begin catch      [ { sql_statement | statement_block } ] end catch [ ; ]

http://msdn.microsoft.com/en-us/library/ms175976.aspx

alternatively break sprocs logical divisions , surround each call on error goto next blocks in vba. latter option pretty dirty hack though, believe.


Comments

Post a Comment

Popular posts from this blog

Javascript line number mapping -

-
magically formatted comments change reported line number of javascript errors in browsers; this: //@line n "f" n line number , f file name. unfortunately, //@line appears ungoogleable. know there documentation on feature, , browsers support it? (i found references here , here .) from can find available in mozilla based browsers. it using js_setoptions command can turn these options on or off depending on values passed. https://developer.mozilla.org/en/js_setoptions
Read more

c# - Is it possible to remove an existing registration from Autofac container builder? -

-
something along lines: builder.registertype<mytype>().as<itype>(); builder.registertype<mytype2>().as<itype>(); builder.deregistertype<mytype>().as<itype>() var container = builder.build(); var types = container.resolve<ienumerable<itype>>(); assert.istrue(types.count == 1); assert.istrue(types[0].gettype == typeof(mytype2)); scenario: go through bunch of assemblies , go register types want make sure have 1 implementation of given type. need before create container. track on own nice if autofac me bit. this cannot done directly using containerbuilder , unless start on new one. mind you, having first built container should able construct new container filtering away unwanted types , reusing registrations first container. this: ... var container = builder.build(); builder = new containerbuilder(); var components = container.componentregistry.registrations .where(cr => cr.activator.limittype != typ...
Read more

php - Mysql PK and FK char(36) vs int(10) -

-
i have read mysql can handle indexes , searches better if tables keys integers rather char(36) uuid's. is worth converting int(10)? note: use 1 server , have have plans use multiple databases concurrently therefore removing 1 of big reasons using uuid. our tables innodb if makes difference. thanks in advance. usually rdbms can handle integer keys pk more efficient, other datatypes. reason how build index column, yes: long dont require string (or other typed) keys, should use integers. however: char(36) , int(10) far away being equal, because int(10) much smaller, char(36). dont know, if require many different keys, should keep in mind. update, complete last paragraph: int(10) 32-bit, char(36) 36 - ^byte^ (= 288-bit). not mean, int consumes less space, means, char(36) has 4 times more different keys.
Read more