What Is Commit
What Is Commit?
✍: fyicenter.com
Commit is an event that attempts to make data in the database identical to the data in the form. It involves writing or posting data to the database and committing data to the database. Forms check the validity of the data in fields and records during a commit. Validity check are uniqueness, consistency and db restrictions.
2007-04-15, 5193👍, 0💬
Related Topics:
What Is Posting
What Is Posting? Posting is an event that writes Inserts, Updates and Deletes in the forms to the database but not committing these transactions to the database. 2007-04-15, 7118👍, 0💬
What Is Consistency
What Is Consistency? Consistency : Assures users that the data they are changing or viewing is not changed until the are through with it. 2007-04-15, 5493👍, 0💬
What Is Rollback
What Is Rollback? Rollback causes work in the current transaction to be undone. 2007-04-15, 5375👍, 0💬
What Is a Savepoint
What Is a Savepoint? Savepoint is a point within a particular transaction to which you may rollback without rolling back the entire transaction. 2007-04-15, 5252👍, 0💬
What Is Locking
What Is Locking? Locking are mechanisms intended to prevent destructive interaction between users accessing data. Locks are used to achieve. 2007-04-15, 5187👍, 0💬
In What Order Different Parts of SQL Statements Are Executed
In What Order Different Parts of SQL Statements Are Executed? Where clause, Group By clause, Having clause, Order By clause and Select. 2007-04-15, 5180👍, 0💬