Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 19 in printed book and digital formats -- plus a one-year subscription (beginning with 20.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview

Buy Now

Issue 5.2


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.


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.