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

Eugene_Dakin · February 21, 2021, 9:20pm

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

Joost_Rongen1 · February 22, 2021, 6:19am

Thanks @Eugene_Dakin Great work.

TimStreater · February 22, 2021, 11:57am

Why is:

Call myfunc ()

legacy?

Eugene_Dakin · February 22, 2021, 2:44pm

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.

TimStreater · February 22, 2021, 3:09pm

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:

https://docs.xojo.com/Call

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