SQLite connection in web app

Databases
1

Hi All

I have been following the xojo video below for connecting to the sqlite database for the web app

Considerations when using a database with a web application — Xojo documentation

but when Copying the code I have a number of errors

please see the two graphics to compare.

Ist error shows “must use object with is”
2nd error shows “this Item does not exist”
3rd is “Syntax error”
4th “Syntax error”

XOJO_MY_Screen
XOJO_MY_Screen878×643 54.6 KB

XOJOSITE
XOJOSITE1009×700 60.2 KB

Thanks in advance

2

There should be a list of the errors with more information at the bottom. The video is from 2016, a lot has changed for Xojo web since then.

What I see:

  • msgbox is no longer used, you need to change that to MessageBox
  • CustomerList.AddRow line is missing the closing parentheses )
  • missing parentheses will also mark wend as an error (I think)

What I don’t know:

  • why the first line is marked as an error. I did a test here and I don’t get an error for that. If you fix the other things and you can’t figure it out, you can share your project and we can take a look.

Hope this helps.

3

Thanks for the swift response I’ve managed to correct all the errors , the first line was resolved by double clicking the errors at the bottom of the screen which showed the ‘t’ was missing from the ‘then’ even though the main screen above displayed correctly … most strange!

Once again thanks for the help I will keep trying to get the rest working but its not helping the video is from 2016!

Grant