Tx.executeSql(CreateTb1,, tblonsucc, tblonError) Var db = openDatabase('TestDB', '1.0', 'Testing Purpose', 200000) // Open SQLite Databaseįunction createTable() // Function for Create Table in SQLite.

Var DefaultInsert = 'INSERT INTO tbl1(CreatedDate,Name) select '' + new Date() + '','Merbin Joe' WHERE NOT EXISTS(select * from tbl1)' Var CreateTb2 = 'CREATE TABLE IF NOT EXISTS tbl2(ID INTEGER PRIMARY KEY AUTOINCREMENT, CreatedDate TEXT,LastModifiedDate TEXT,Mark INTEGER)' Startup.js var CreateTb1 = 'CREATE TABLE IF NOT EXISTS tbl1(ID INTEGER PRIMARY KEY AUTOINCREMENT, CreatedDate TEXT,LastModifiedDate TEXT, Name TEXT)' In my sqlite code I am using three js file for controlling sqlite one for debugging purpose, one for executing querys and another one for initilize the database and create basic tables. If (result != null & result.rows != null) )

Transaction.executeSql('SELECT * FROM User ', ,

Now my question is how do I open that database in my code? Right now I'm using the following code: var db ĭb = openDatabase(shortName, version, displayName,maxSize) I have made a file 'myDatabase.sqlite' in an SQLite tool. I am trying to connect to a SQLite databse by using Javascript.

Opendatabase sqlite