Sometimes ago, without internet access, I needed some SQL help and do not have it.
I created one that I share now with an example using SQLite.
The two projects (xojo_binary_project) were created with Xojo 2021r2.1.
Nota: I’ve made a design error; I used information from SQL Tutorial and some informations does not works with SQLite / not implemented in SQLite.
The screen shot below represent the moment in time when I realized I’d better create an example Data Base project instead of adding Xojo code in the original project.
Enjoy it (them).
Of course, you may find some misfeat (typos, errors, etc.). You are encouraged to report them to me.
BTW: I added a screen shot of a different .sqlite graphics structure only to display the limits of the example (too many tables to be reported in that “small” screen.
That is the last feature I add and was … tired ! So, if someone can modify it to overcome this limit: welcome to share the code.
As you can see in the screen shot, the many lines SQL examples can be coded in a similar way with Xojo; but this is not mandatory: I do it that way, so you know what to do with the SQL code example you will find in the web.
The used data base (structure and data) was taken from www.w3schools.com as they use that in their examples.
Ideas to add features, etc. are welcome too.
I hope you will enjoy that code sharing.
BTW: I knew I was forgetting something… the URL !
There are two folders there.