SqlOpenDatabase: Difference between revisions

From NSB App Studio
Jump to navigation Jump to search
No edit summary
 
(One intermediate revision by the same user not shown)
Line 3: Line 3:
== 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.


''dbName'' is the name of the database. If ''dbName'' does not exist, it is created. The database is created in temporary memory, unless the name is ''localStorage''.
''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]].
For more information on SQLite, see [[Using SQLite]].

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

Related Items

Sql

SQLite Reference

Using SQLite