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 17 in printed book and digital formats -- plus a one-year subscription (beginning with 18.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 4.5


Databases for Real

REALSQLDatabase (SQLite)

Issue: 4.5 (May/June 2006)
Author Bio: Paul Lefebvre is President and Chief Software Architect of LogicalVue Software.
Article Description: No description available.
Article Length (in bytes): 5,599
Starting Page Number: 36
Article Number: 4512
Related Web Link(s):


Excerpt of article text...

Today we will discuss the various REAL SQL Database commands for manipulating data in a database. These commands are listed in Table 1. We'll stick with the simple URL database example from last time as we look at these commands.

Adding Data to Your Tables

None of the other commands mean much if you don't have any data in your tables. Data is added using the INSERT command. The SQLite INSERT commands works pretty much the same as INSERT for any other database. A quick example:

INSERT INTO bookmark (URL, Description) VALUES ('http://www.sqlite.org', 'SQLite Website')

...End of Excerpt. Please purchase the magazine to read the full article.