DataWindow.Commit Method

Request Example View Source

Return Value

Type: Usual
TRUE if successful; otherwise, FALSE.

This method also makes the changes visible to other users on other machines on a network, as well as to other applications on the same machine. Prior to DataWindow:Commit(), the changes are guaranteed to be visible only to other data windows connected to the same server within the same application. DataWindow: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 DataServer:Status property to determine the exact cause of the failure. You should also note that there is no guarantee that changes which have not been committed can be rolled back. The rollback capabilities depend on the particular data server implementation (for example, SQLSelect can usually do it—depending on the particular SQL database in use—but DBServer cannot). For details, please refer to the documentation on the specific server you intend to use.