SQLite150I 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.

Elephant200x200PostgreSQL is an enterprise database which has many built-in attributes that are expected: complex transactional loads, multi-users, fast, and stable.

Here are a few areas of the many example provided and discussed:

  • Joins
  • Thread and Progress Bar
  • Transaction
  • Alias
  • CRUD (Create, Read, Update, Delete)
  • Reports
  • Prepared Statements

Tested on Windows 8.1 and Mac Maverick OS's Desktop Applications And more...

excel 2007This book “I Wish I Knew How to … Program Excel with Real Studio in Windows” goes into the numerous options of programming Excel.
This guide uses the power of Real Studio in conjunction with the power of Excel. The question is frequently asked ‘why not just create the program in Excel?’ The answer is confidentiality, security, and automation. It is relatively common knowledge that program created in Excel are not secure and can be easily modified to view the original formulas for calculating results – no matter how much protection has been placed in the original program.

PixelationCanvasI Wish I Knew How To… Program the Canvas Control with Xojo Desktop will provide you with the ability to learn how to modify pictures, graphics, make animation, and how to make two games.
The focus of this book is to work with topics related to the Canvas Control. All of these examples are created with native Xojo code and does not use any third party programs. The examples have been tested on Windows 7, 8.1, OS X 10.9, and Ubuntu 14.04 Operating Systems.
By the time you finish the book you will be able to apply skills from these examples to create your own programs!
Examples were tested on Xojo 2014 r2.