Program SQLite book updated to Version 2.5

Databases
1

I Wish I Knew How To… Program #SQLite with #Xojo API2 Version 2.5 book has been released. It is a free update for Version 2.x purchasers. More book information can be viewed at scispec.ca/index.php/books and can be purchased at xdevlibrary.com

Instructions to download an updated version are:

  1. Go to the link: Gumroad Library
  2. Past purchases should show up on the Library page
  3. Download the latest version of the book

SQLite25

There are many updates to this book, and more will be released in the near future.

Updates to Version 2.5 – Sep 2023

  • Focus on latest updates to API2 version with 2023 R2
  • Updated Desktop, BevelButton, DesktopApplication, DesktopWindow, Action to Pressed Event, DesktopLabel, changed Menubar to API2 (Example 1-1)
  • Update DesktopApplication, DesktopWindow, DesktopButton, Binary Project, Button Pressed Event, MenuBar, DesktopLabel to API2 (Example3-1)
  • Update DesktopApplication, DesktopWindow, DesktopButton, Binary Project, DesktopButton Pressed Event, MenuBar, DesktopLabel, to API2 (Example 3-2)
  • Example 3-3, updated DesktopApplication, DesktopWindow, DesktopButton, Project file binary, MenuBar, DesktopButton, Desktopbutton Pressed event, and DesktopLabel.
  • Example 4-1, changed to newer controls, DesktopApplication, DesktopWindow, DesktopButton, DesktopTextField, changed to new binary project format, DesktopButton to Pressed action event, Menubar, and DesktopLabel. Updated code in example.
  • Changed following controls and new API2 compatible items, DesktopApplication, DesktopWindow, DesktopButton, DesktopTextField, DesktopLabel, new binary project, New Desktopbutton Pressed event, book code, and Menubar in Example 4-2.
  • Example 4-3 updated items: DesktopApplication, DesktopWindow, DesktopButton, DesktopLabel, DesktopComboBox, new binary project format, new button Pressed event, MenuBar, and the code in book for this example.
  • Modified the following controls and code: DesktopApplication, DesktopWindow, DesktopButton, binary project, DesktopButton Pressed Event, MenuBar, DesktopListBox, CellTextAt, changed code in book with Example 4-4.
  • Changed code and controls in Example 4-5 to: DesktopApplication, DesktopWindow, DesktopButton, new binary project format, DesktopButton Pressed event, MenuBar, DesktopListBox, CellTextAt, and updated example book code for Example 4-5.
  • Update Example 4-6 with further updates to API2 controls and code, DesktopApplication, DesktopWindow, DesktopButton, Binary Project, Pressed DesktopButton event, MenuBar, DesktopListbox, Code CellTextAt in book code.
  • Changed and updated to the following API2 code and control changes: DesktopApplication, DesktopWindow, DesktopButton, binary project, Desktopbutton Pressed event, MenuBar, DesktopListbox, CellTextAt, and book code for Example 4-7.
  • Example 4-8 updates to code and desktop controls are as follows: DesktopApplication, DesktopWindow, DesktopButton, binary project update, DesktopButton Pressed event, MenuBar, DesktopListbox, CellTextAt, DesktopTextField, and DesktopLabel.
  • Updated Example 4-9 with the following: DesktopApplication, DesktopWindow, DesktopButton, update binary project, DesktopButton Pressed event, MenuBar, DesktopListbox, DesktopTextfield, Code CellTextAt, and DesktopLabel.
  • The following items were updated: DesktopApplication, DesktopWindow, DesktopButton, DesktopListbox, DesktopTextbox, DesktopLabel, binary project updates, Implement Pressed event, CellTextAt, code, and MenuBar for Example 4-10.
  • Example 4-11 has been updated with: DesktopApplication, DesktopWindow, DesktopButton, DesktopListbox, DesktopTextfield, Update binary project, Pressed event for DesktopButton, MenuBar, and CellTextAt.
  • Updated Example 5-1 with the following modifications: DesktopApplication, DesktopWindow, DesktopButton, Pressed event, Opening Event, Closing Event, binary project format, MenuBar, DesktopLabel, DesktopListbox, and CellTextAt.
  • Updated the following deprecated items: DesktopApplication, DesktopWindow, DesktopButton, DesktopListbox, DesktopLabel, update binary project, Pressed event, Opening event, MenuBar, and CellTextAt for Example 5-2.
  • Example 5-3 has been updated to more API2 code: DesktopApplication, DesktopWindow, DesktopButton, DesktopListbox, DesktopLabel, updated binary project, DesktopButton Pressed and Opening event, MenuBar, DesktopListbox CellTextAt, and DesktopTextField.
  • Updated the following code and controls in Example 5-3: binary project, DesktopApplication, DesktopWindow, DesktopButton, DesktopListbox, DesktopLabels, DesktopButton Pressed and Opening Event, DesktopListbox CellTextAt, MenuBar, DesktopTextfields, and DesktopGroupBox.
  • Example 5-4 has updates which include: binary project, DesktopApplication, DesktopWindow, DesktopButton, DesktopListbox, DesktopLabels, DesktopButton Pressed and Opening Event, DesktopListbox CellTextAt, MenuBar, DesktopTextfields, and DesktopGroupBox.
  • The following code and controls were updated: DesktopApplication, DesktopWindow, DesktopButton, binary project, Pressed and Opening Event, MenuBar, DesktopListbox, CellTextAt, DesktopTextField, and DesktopLabel for Example 5-5.
  • Example 6-1 has the following updates: updated binary project, DesktopApplication, DesktopWindow, MenuBar, DesktopButton, Pressed and Opening event, DesktopListbox, CellTextAt, and DesktopLabel.
  • Code and controls for Example 6-2 has been updated with the following items: xojo binary project, DesktopApplication, DesktopWindow, DesktopButton, DesktopListbox, DesktopGroupBox, DesktopButton Pressed and Opening event, MenuBar, DesktopListbox, CellTextAt, DesktopLabels, and DesktopTextFields.
  • Further APII2 updates were created in Example 6-3 which contain the following code and controls: binary project, DesktopApplication, DesktopWindow, DesktopButton, DesktopListbox, DesktopGroupBox, DesktopLabel, DesktopTextField, DesktopButton Opening and Pressed events, MenuBar, and DesktopListbox CellTextAt code.
  • Example 7-1 has had updates to code and controls which are: DesktopApplication, binary project, and MenuBar major modifications.
  • Updates to code and controls for Example 8-1 include the following: DesktopApplication, DesktopWindow, binary project, DesktopListbox, DesktopButton, DesktopButton Pressed event, DesktopListbox CellTextAt code, and MenuBar.
  • Control updates to Example 8-2 with controls have occurred in this project: binary project, DesktopApplication, DesktopWindow, DesktopButton, DesktopLabel, DesktopButton Pressed event, and MenuBar.
  • Example 9-1 project had the following updates: DesktopApplication, binary project, DesktopWindow, MenuBar, DesktopLabel, DesktopButton, and DesktopButton Pressed event.
  • Updated to API 2 with the latest code and controls, binary project, DesktopApplication, DesktopWindow, DesktopButton, DesktopLabel, DesktopButton Pressed event, and Menubar.
  • Upgraded Example 9-3 to API 2 code with the following modifications: DesktopWindow, DesktopApplication, binary project, MenuBar, DesktopLabel, and DesktopButton.
  • Example 9-4 updated with the following controls: DesktopApplication, MenuBar, binary project, DesktopWindow, DesktopLabel, DesktopButton, and Pressed event for DesktopPushbutton.
  • Controls were updated as DesktopApplication, binary project, DesktopWindow, DesktopLabel, MenuBar, DesktopButton, DesktopButton Pressed Event for Example 9-5.
  • Updated the following controls in Example 10-1 : DesktopApplication, binary project, MenuBar, DesktopWindow, DesktopButton, DesktopListbox, DesktopListbox CelltextAt command, DesktopButton Opening and Pressed events.
  • Example 10-2 updates include: binary project, DesktopApplication, DesktopWindow, DesktopButton, DesktopTextField, DesktopLabel, DesktopListbox, MenuBar, DesktopListbox CellTextAt command, DesktopButton Opening and Pressed events.
  • Formatting numbers in Example 11-1 example was update with the following code and controls, DesktopApplication, binary project, DesktopWindow, ManuBar, DesktopButton, DesktopButton Pressed event, DesktopListbox, DesktopListbox CellTextAt command.
  • API2 code has been updated in Example 12-1 with the following code and controls: DesktopApplication, binary project, DesktopWindow, DesktopButton, DesktopButton Pressed event, MenuBar, PrinterSetup ShowPrinterDialog code, ReportLabel, and update code to new API2 code.
  • Example 12-2 is updated to API2, updating DesktopApplication, DesktopWindow, DesktopButton, binary project, DesktopButton with Pressed method, MenuBar, OpenFileDialog, and MessageDialog Show command.
  • New report created in Example 12-3 with updates, DesktopApplication, binary project, DesktopWindow, DesktopButton, MenuBar, and rewrote printing code.
  • Example 12-4 has updates to: DesktopApplication, binary project, DesktopWindow, DesktopButton, DesktopButton Pressed Event, and DesktopMenuBar.
  • API2 has been updated along with code and contains edits to the following controls and code: DesktopApplication, binary project, DesktopWindow, DesktopButton, DesktopButton Pressed event, DesktopMenuBar for Example 12-5.
  • Updated code to API2 with Example 12-6, and to the following controls: Binary project, DesktopApplication, DesktopWindow, DesktopButton, DesktopButton Pressed event, MenuBar,
  • Example 12-7 code to more API2 compatible controls, such as: binary project, DesktopApplication, DesktopButton, DesktopWindow, DesktopButton Pressed Event, DesktopMenuBar, and updated code in the Pressed event.
  • The following updates to code and controls to API2 have occurd in Example 12-8: DesktopApplication, binary project, DesktopWindow, DesktopButton, DesktopButton Pressed event, DesktopMenuBar, and updated printing code.
  • Updated code and controls on Example 12-9 which are as follows: DesktopApplication, binary project format, DesktopWindow, DesktopButton, DesktopButton Pressed Event, DesktopMenuBar, and updated printing code in the Pressed event.
  • Example 12-10 has more API2 code added, and the list of changes are: binary project, DesktopApplication, DesktopWindow, DesktopMenuBar, DesktopButton, DesktopButton Pressed Event, and ran into crashes. Code is included although there are bugs. Note: Multiple crashes have occurred with workarounds – this code is for testing and not to be used in a final project.
  • Updated code and controls in Example 12-11 which include the following: Binary project, DesktopApplication, DesktopMenuBar, DesktopWindow, DesktopButton, and DesktopButton Pressed event. Although the landscape command worked on Printersetup, it does not work on the final print – code is for testing and not to be used in a final project
  • Due to a large number of errors in creating reports with Desktop Reports in API2, most report examples have not been updated in the book until creating reports have stabilized.
  • Example 13-1 has been updated to API2 with the following modifications: DesktopApplication, binary project, DesktopWindow, DesktopButton, DesktopButton Pressed event, DesktopMenuBar, and DesktopLabel.
1 Like