XMLLogo200There are many points to learn XML, such as connecting databases, displaying data in multiple formats, making the information tailored to the reader, adding security through schemas and more.  With Xojo’s ability to work on multiple operating systems, using XML adds to the already diverse Xojo environment.

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.

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