Accessing a local SQLite database

Happy to have hurdled a stumbling block, on accessing an sqlite database. I watched Dana Brown’s short webinar " Xojo Desktop App Database Tutorial: Connecting a SQLite Database", and just followed it faithfully. The code that works for me are:

db = New SqLiteDatabase
var f as FolderItem = SpecialFolder.Resource(“bisoogo.sqlite”)

Thanks to all who responded and gave me many ideas.

1 Like

You better not do that. Storing data inside the application is not something to do.

Go to the documentation and search SpecialFolder for a location to store your data, eventually.
(Or use SpecialFolder.Documents until you will be ready to do it better).

1 Like