Method USqlStatement():openDatabase() Foundation

Opens or creates a SQLite database.

Syntax
:openDatabase( <cFile> ) -> self
Parameters
<cFile>
The SQLite database file.
Return

Returns self.

Description

The method :openDatabase() opens a SQLite database by its filename. If no path is given, the current directory is used to search for the database file. If the file is not found, the database is created. Use the File() function to test for the existence of the database file.

Opening a database closes the current database and any attached databases. This includes the global in-memory database, which is the default current database, and all virtual tables created using functions such as :createVirtualTableFromWorkarea(). The global in-memory database is reopened when the SQLite database is closed later using :closeDatabase().

Feedback

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.