I am trying to follow this page to create a database connection with the UI so I can apply this to my own app, but I am getting so many errors even after simply copy pasting the example code. Is this example database somewhere available as download so I can see what I am doing wrong?
Have you looked in the Xojo folder?
There is a folder Example Projects.
In that folder Database > SQLite
You can start with examining SQLiteExample.xojo_binary_project.