Creating an SQLite database on the fly in code

Getting Started
1

Hi all,

Please, can you help me with the following request?

For my bookkeeping application, I need to manually create an SQLite database, tables and queries in code.

I did the same in 2007 - 2008 with RealStudio. I had a PDF file which nicely explained the whole process. Regretfully, I cannot find it again.

Please, can you tell me where I can find text tutorials and/or video tutorials which explain manual coding of an SQLite database?

Thank you so much in advance. Your help will be greatly appreciated.

Chris

2

https://documentation.xojo.com/topics/databases/supported_engines/sqlite/sqlite_basics.html#sqlite-basics

may be of some help (I hope).
db reference must be closed as soon as possible, after immediate use.

3

@Emile_Schwarz ,

Thank you so much, exactly what I was looking for.

Chris