SqlOpenDatabase: Difference between revisions
Jump to navigation
Jump to search
m Ghenne moved page Sqlopendatabase to SqlOpenDatabase |
|||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
SqlOpenDatabase('' | SqlOpenDatabase(''dbName'') | ||
== Description == | == Description == | ||
SqlOpenDataBase is used to create and open SQLite databases. | SqlOpenDataBase is used to create and open SQLite databases. It works with both the SQLite WASM library and the Cordova SQLite plugin. | ||
If '' | ''dbName'' is the name of the database. If ''dbName'' does not exist, it is created. The database is created in localStorage by default. If another name is supplied, it is created as that name - but will not persist if the app is restarted. | ||
For more information, see | For more information on SQLite, see [[Using SQLite]]. | ||
== Example == | == Example == | ||
| Line 13: | Line 13: | ||
<pre> | <pre> | ||
Rem SqlOpenDatabase sample | Rem SqlOpenDatabase sample | ||
DB = SqlOpenDatabase("customers.db" | DB = SqlOpenDatabase("customers.db") | ||
Print "Database version is " & DB.version</pre> | If DB.version <> "" Then | ||
Print "Database version is " & DB.version | |||
Else | |||
print "Database not found." | |||
End If | |||
</pre> | |||
== Output == | == Output == | ||
| Line 25: | Line 30: | ||
[[sql|Sql]] | [[sql|Sql]] | ||
[[SQLite Reference]] | |||
[[Using SQLite]] | |||
[[Category:Language Reference]] | [[Category:Language Reference]] | ||
[[Category:Miscellaneous]] | [[Category:Miscellaneous]] | ||
Latest revision as of 14:05, 28 August 2024
SqlOpenDatabase(dbName)
Description
SqlOpenDataBase is used to create and open SQLite databases. It works with both the SQLite WASM library and the Cordova SQLite plugin.
dbName is the name of the database. If dbName does not exist, it is created. The database is created in localStorage by default. If another name is supplied, it is created as that name - but will not persist if the app is restarted.
For more information on SQLite, see Using SQLite.
Example
Rem SqlOpenDatabase sample
DB = SqlOpenDatabase("customers.db")
If DB.version <> "" Then
Print "Database version is " & DB.version
Else
print "Database not found."
End If
Output
Database version is 1.0