I Wish I Knew How to … Program SQLite with Xojo Desktop delves into the mystery of programming a front end database.
The book is written as a guide and reference to Xojo programmers who program Desktop Applications in Windows and Mac. There are no plugins, dynamic link libraries (dll), COM, or Active X parts to add.
There are more than 20 chapters with over 350 pages with over 70 example programs.
Examples include opening recordsets, finding data, sorting, updating data, counting records, printing a report, deleting records, creating new records, creating reports, and more. Many screenshots have been added to show the results of the code with an index to help find topics quickly.
*This uses Xojo API1
Click to download the latest version of the Table Of Contents which also has an example from the book.
This is one of many books at Xojo Library.
March 2015 (1.2 Edition) has minor updates which are:
- BD Maintenance (Analyze) in section Other-1
- Added more items to book index (DQL: INSERT INTO, etc.)
- Added data with recordset (Example 6-3)
- Updated saved examples to Xojo 2015 r1 format
- Added multiuser (WAL) example (Example 25-2)
Note: There were a few issues and errors noticed with the Xojo Report portion of the program. Most of the problems appear to be with the way margins are treated on Windows and Mac. The Windows OS defaults to a 1" margin on all sides of a page, while the Mac OS seems to default to a 0" margin on all sides.
There are some workarounds shown in the book to help modify the reports to be compatible on both Windows and Macs, and solutions were not available for all report issues. The book is in PDF format with example chapter folders containing Xojo source code and running examples.