SQLite


SQLite is one of the most widely used database engines. In contrast to other databases, SQLite is not a separate process that is accessed from the client application, but an integral part of the Android operating system. SQLite is compact and widely used by all sorts of apps.

Basic implements SQLite's functionality through simple function calls. SQLite stores the entire database (definitions, tables, indices, and the data itself) as a single cross-platform file in the Data directory on your SD card. It implements this simple design by locking the entire database file during writing.

This reference will not try to teach you SQLite. Only the basics will be covered in this text. Example code will be provided wherever possible, but you should refer to a book or online source for more complex uses of SQLite. All SQLite functionality is accessible through Mintoris Basic.

Please feel free to ask questions and share results in the online Basic Forum.


SqlOpen


SqlClose


SqlAddTable


SqlDelTable


SqlInsert


SqlUpdate


SqlDelete


SqlExec


SetOnSqlExceptionSub


SqlGetTableNames$(n)


SQLite Cursor






Become a Patron