Article Preview
Buy Now
COLUMN
REALSQLDatabase (SQLite)
Triggers and Views
Issue: 5.2 (January/February 2007)
Author Bio: Paul Lefebvre is President and Chief Software Architect of LogicalVue Software.
Article Description: No description available.
Article Length (in bytes): 4,951
Starting Page Number: 36
Article Number: 5213
Related Link(s): None
Excerpt of article text...
For my last column on REALSQLDatabase/SQLite topics, we'll be covering transactions and a couple administration commands.
Transactions
A transaction is simply a group of database statements that will change the database in some way. You create a transaction when you want all these changes to be applied together or to not be applied at all, such as when there is a failure.
A typical example is a bank transfer. A bank transfer involves adding money to one account while removing it from another account. On the surface, that seems rather simple. This is what two SQL statements might look like to do this:
...End of Excerpt. Please purchase the magazine to read the full article.