SQLSelect.Commit Method |  |
Save the changes (updates and deletes) made since the last Commit().
Namespace: VO
Assembly: VOSQLClasses (in VOSQLClasses.dll) Version: 2.21
SyntaxRequest Example
View Source
TRUE if successful; otherwise, FALSE. Commit() can fail for many reasons, from a lack of capability in the server to lock conflicts to technical problems such as network crashes. Use the SQLSelect:Status property to determine the exact cause of the failure.
Return Value
Type: UsualTRUE if successful; otherwise, FALSE. Commit() can fail for many reasons, from a lack of capability in the server to lock conflicts to technical problems such as network crashes. Use the SQLSelect:Status property to determine the exact cause of the failure.
Remarks
The exact implications of this action depend on the server. With some database management systems, the method commits all servers using the same connection; with others, it commits only this server; and with yet others the method does nothing. In addition, some SQL servers have other implications of a commit operation (they can close cursors, for example). This is an area that is not standardized; you should carefully study the documentation for your database management system.
The AutoCommit option may interfere with manual commits. You may want to turn AutoCommit off, for example:
X#
1oSelect:Connection:SetConnectOption(SQL_AUTOCOMMIT, 0)
See Also