>Hi,
>
>From VFP i'm persisting data into SQLServer, but roolback transaction dont work
>
>

>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.