From Xojo Documentation
|You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!|
| This item was deprecated in version 2020r2.
Please use SQLiteDatabase as a replacement.
| This class is supported on Mobile (iOS).
Use ＃If...＃Endif with the Target... constants to ensure you only use this class where it is supported.
Provides access to SQLite databases in iOS projects.
|Xojo Version||SQLite Version|
For more information about SQLite:
If your database object goes out of scope, the database is closed. This means you are typically going to want your database object be somewhat global to your app. A common technique is to have an iOSSQLiteDatabase property on the App object that you refer throughout your app as App.DB.
iOSSQLiteDatabase does an auto-commit after each SQL command if you do not manually start a transaction. You can start a transaction using this command:
When the transaction is complete, you commit your changes with this command:
You can cancel a transaction by calling rollback with this command: