|
| |
| ||||||||||||||||||
Purpose
Commits a transaction on a data source.
 Note This method is only available to data sources that support transactions. Commit is not a valid operation for connections that have AutoCommit turned on.
Syntax
DBConnection.Commit
Example
Sub Main()
Dim cnct as DBConnection
cnct.OpenConnection("MyDSN") 'Open the data source "MyDSN"
cnct.AutoCommit = SQL_AUTOCOMMIT_OFF
'Begin the transaction
' Create statements and execute SQL...
' ...
If (UserClickedCancel = TRUE)
cnct.Rollback 'Rollback changes
Else
cnct.Commit 'Commit changes
End if
cnct.CloseConnection 'Close the connection
End Sub
| ||