SQLite with Xojo (RBL-0051)

SQLite is a zero-configuration, serverless, transactional, and self-contained database. Here are a few areas of the many examples provided and discussed:

* Joins

* Thread and Progress Bar

* Transaction

* Alias

* Encryption/Decryption

* CRUD (Create, Read, Update, Delete)

* Reports

* Prepared Statements (Select, Update, Delete, Insert)

* SQL Injection

* SQLite Reserved Words

* Delete Field Workaround

* Add Table field

* Rename existing Table

There are over 300 pages, greater than 70 example programs which cover over 20 chapters.

New to Version 1.2 – March 2015: This version has the following material added:

* Maintenance (Analyze) Other-1

* Added more items to book index (SQL: INSERT INTO, etc.)

* Add data with a recordset (Example 6-3)

* Updated saved examples to Xojo 2015 r1 format

* Added multiuser (WAL) example (Example 25-2)