To commit or not to commit

Ollie Zent

Delphi Developer

Mon, 08 Dec 2003 16:45:06 GMT

To commit or not to commit

Could anyone pls explain the art of transactions (commit, rollback) when
connecting to a MSSQL database and perhaps write som sample code.
If using an update statement with a TQuery component, do I have to commit
the change in data or does the BDE does it for me? If I need to but don't,
what happens in MSSQL. Does the transaction log grow unwantedly and in that
case, will these noncommited transactions not be cleared at the next backup
of the database and log?
Many questions - pls bare with me.

Ollie

Other Threads

1. When a commit is not a commit

2. commit does not commit

3. Two fase commit. Partial Commit

4. Commit fails to Commit

5. Transaction.Commit vs. using SQL to call COMMIT

6. Delphi 3 DBError can not commit or rollback before begintrans

7. TDatabase InTransaction property not set to False after call to Rollback or Commit

8. Query.Open commits transaction or not?

9. can not commit

10. Access violation on database.commit with foxpro database(odbc driver not native)