I hear a lot from people that want to make database apps using Xojo but don’t know where to get started.
Since this comes up so often, I’d like to take a moment to point people in the direction of the many resources available to you to learn how to use databases with Xojo.
First, Xojo works with a wide variety of databases. Direct support is included for these databases: SQLite, PostgreSQL, MySQL, Oracle Database and Microsoft SQL Server. Plus you can use ODBC to connect to just about anything else, such as Microsoft Access, Firebird or even IBM iSeries.
To help you get started, you can check out the database examples that are included with Xojo. There are examples that can connect to each of the supported databases in the Examples/Databases folder.
The Xojo User Guide has a chapter on Databases that covers all the supported databases and provides lots of information to get you started:
Xojo User Guide Book 3: Framework, Chapter 4: Databases
The Language Reference has the details of the all the database classes, which you can view here:
There are also several database webinars that you can watch:
Lastly, you should always refer to the vendor-specific documentation for the database you are using to learn the specifics about how the database works, including SQL syntax.