Back

OpenDatabase

Hello World

Content:
- Methods

OpenDatabase creates or opens a local database in which large amounts of data can be stored that can still be queried in a reasonable amount of time.

db = app.OpenDatabase( name ) → app object: Database

Methods

The following methods are available on the Database object:

addTransaction( transaction )

close( success, error )

Close()

Delete()

executeSql( statement, params, success, error )

ExecuteSql( sql, params, success, error )

GetName() → String

GetType() → String: “Database”

name → String

open( success, error )

readTransaction( fn, error, success )

startNextTransaction()

transaction( fn, error, success )

List

String

String: sql code

Object: JS SQLitePluginTransaction

Object: { db: { openargs: { name, dblocation }, dbname, name }, txlock, readOnly, executes: [{ success, qid, sql, params }] }

Object: { rows.item(i): { id, data, data_num } }

Object: { message }

Object: { length, rowsAffected, rows.item(i): { id, data, data_num } }

function( msg )

function( tx, res )

function( t, err )

function( res )

function( err )

function()

function( tx )

function( fnc, res )

db.addTransaction
addTransaction

Note: This function is deprecated. Use ExecuteSQL instead

db.close
Close the database

Note: This function is deprecated. Use Close instead

db.Close
Close the database

db.Delete
Delete the database

db.executeSql
Executes a SQL query

Note: This function is deprecated. Use ExecuteSql instead

db.ExecuteSql
Executes a SQL query

db.GetName
Returns the database name

db.GetType
Returns the component class name.

The database name

Note: This function is deprecated. use GetName instead

db.open
Opens the database

Note: This function is deprecated.

db.readTransaction
readTransaction

Note: This function is deprecated. Use ExecuteSql instead

db.startNextTransaction
startNextTransaction

Note: This function is deprecated. Use ExecuteSql instead

db.transaction
transaction

Note: This function is deprecated. Use ExecuteSql instead