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.

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

I Wish I Knew How To ... Begin Programming Xojo Web is an introductory book which will give you the tools and knowledge to begin programming a webpage for the internet. This book includes static and dynamic webpages which can also be integrated with a database.

This book introduces many of the fundamentals to create webpages which include CGI and Standalone applications. Both HTTP and HTTPS standalone examples are covered with a focus on HTTP CGI's. There are many different configurations for a complete HTTP and HTTPS CGI server and are beyond this introductory writing and are only lightly discussed. Working examples are for the Xojo Web class and does not cover socket examples, as this is a complete book on its own.