>objConexao.executar("BEGIN TRANSACTION") >objConexao.executar("Update TableName set fieldname = 11 where fieldkey = 289880") >objConexao.executar("ROLLBACK TRANSACTION") && dont work - in SQLServer fieldname was updated to 11 >You should pass all 3 commands at once, e.g.
text to lcUpdate noshow BEGIN TRANSACTION Update TableName set fieldname = 11 where fieldkey = 289880 ROLLBACK TRANSACTION endtext objConexao.executar(lcUpdate)This way they will execute as one batch.