In SQLite in Cordova, why do I get "Error preparing SQLite statement" error? -

i'm working on windows 8 cordova app in visual studio 2015. right i'm trying test creating tables error.

below in console log:

adding proxy sqliteplugin open database: nanodb.db db name: nanodb.db @ full path: .[...] new transaction waiting open operation db opened: nanodb.db sql exception error: error preparing sqlite statement. sql exception error: error preparing sqlite statement. sql exception error: error preparing sqlite statement. sql exception error: error preparing sqlite statement. sql exception error: error preparing sqlite statement. sql exception error: error preparing sqlite statement. sql exception error: error preparing sqlite statement. 

this script i'm running inside after "deviceready" listener:

var nanodb = window.sqliteplugin.opendatabase({ name: "nanodb.db" })  nanodb.transaction(function (tx) {      tx.executesql(nanodb, "create table if not exists nanoinst (id integer primary key, api_id integer, name text)");     tx.executesql(nanodb, "create table if not exists nonoprod (id integer primary key, api_id integer, name text)");     tx.executesql(nanodb, "create table if not exists nanoind (id integer primary key, api_id integer, name text)");     tx.executesql(nanodb, "create table if not exists nanofiles (id integer primary key, api_id integer, name text, filetype text, fileloc text)");     tx.executesql(nanodb, "create table if not exists nanorelprod (id integer primary key, inst_id integer, prod_id integer)");     tx.executesql(nanodb, "create table if not exists nanorelind (id integer primary key, inst_id integer, ind_id integer)");     tx.executesql(nanodb, "create table if not exists nanorelfiles (id integer primary key, inst_id integer, file_id integer)"); }); 

you can see db created error when try add tables.

you need pass transaction in executesql call not db.

tx.executesql(tx, "create table if not exists nanoinst (id integer primary key, api_id integer, name text)");