SQLite with Xojo API Book - updated to 2.1 (Feb 2021)

Version 2.1 of the book I Wish I Knew How To … Program SQLite with Xojo API 2 has been released.

This is a free updated to those who have purchased version 2.0 of the book. Here is a list of comments on the updated version:

Updates to Version 2.1 – Feb 2021

  • Grammatical changes
  • Formatting changes
  • Repopulated Example 8-1
  • Performed many updates from CStr to ToString formatting
  • Changed information on DPI for MaximumHorizontalResolution and MaximumVerticalResolution
  • Remove the legacy Call function when no return value is needed for a method, on many examples
  • Changed OLEException (Windows Only) to DatabaseException
  • Write Ahead Logging is added in Example 25-2.
  • Changed IntegerValue.ToString to StringValue
  • Changed DoubleValue.ToString to StringValue
  • Removed extra brackets from dlg.ShowModal
  • Updated Example 15-3 to include a Table and three columns to allow 100 additions. Special thanks to Enric Herrera.

There are more than 20 chapters with over 400 pages with over 80 example programs.

More details and purchasing of the book are available at the following links: https://scispec.ca/index.php/books and http://xojolibrary.com/ .

The books ISBN number is: ISBN: 978-1-927924-29-7


Thanks @Eugene_Dakin Great work.

1 Like

Why is:

Call myfunc ()


1 Like

Hello Tim,

I went through my previous examples and I can’t seem to create an example for your question. When I was updating the book from SQLite API 1 to API 2 with all of the boxes in the Project->Analysis Warnings turned on, I had a report that went something like this: Call is a legacy command, and I removed the Call commands from all examples in the book.

When I run into this comment again, I’ll post an example for you. Thanks for asking.

I was just curious because recently (say, since the start of the year) there was some thread or other that mentioned unused local variables, and that someone was having to define a local variable just to receive the unused return value of a function.

But then @Greg_O_Lone replied that one could use Call instead of declaring a variable, and in fact I’m now using that in a number of places. The doc is here:


but my recollection was that it didn’t mention any reason not to use it. Hence my curiosity.