Transactions, commits & rollbacks

[atferraz]

Helo
how can I apply transaction, commits and rollbacks to a lot of inserts in one script?

thanks anyone

 

[SatishPutcha]

Hi

If your connection object is con

con.BeginTrans - Always needed to implement Transactions

con.CommitTrans - Commits the transactions. All SQL statements after BeginTrans are not 'committed' till it finds CommitTrans.

con.RollBackTrans - Aborts all SQL statements between BeginTrans and RollBackTrans.

Hope this helped.

Regards
Satish

 

[atferraz]

Something like this

Con.BeginTrans
Con.Execute "Update ........." trans1
Con.Execute "Insert ........." trans2
Con.Execute "Delete ........." trans3

If Con.Errors.Count <> 0 Then
Con.RollbackTrans
Else
Con.CommitTrans All or nothing, right?
End if

 

[onpnt]

Con.Open ' open connection
Con.Execute &quot;Update .........&quot; execute trans1
Con.Execute &quot;Insert .........&quot; execute trans2
Con.Execute &quot;Delete .........&quot; execute trans3

also, I do not believe vbscript has .Count for error trapping

http://www.w3schools.com/ado/ado_ref_error.asp

_____________________________________________________________________

http://www.onpntwebdesigns.com

 

[SatishPutcha]

atferraz:

Yes, you got it right. From what I remember, the queries are not 'committed' till you call CommitTrans.

For Error trapping use Err object with On Error Resume Next.

Regards
Satish