Search code examples
sqldatabasephonegap

Run SQL Query in Phonegap

Hello everyone i am trying to run a query as follows, but i always get "SQL ERROR: undefined"

What am i doing wrong.

db = window.openDatabase("Database", "1.0", "SQLDB", 200000);
RunQuery ("DROP TABLE IF EXISTS ARTIGOS");

function RunQuery(QueryExecute) {
    db.transaction(function(transaction){
        transaction.executeSql(QueryExecute,successCB,errorCB);
    })
}

function errorCB(err) {
	alert("SQL Error: "+err.message);
}

function successCB() {
	alert("SQL OK");
}

Solution

  • One possibility is that the transaction.executeSql method takes a parameters array as its second argument. So to use the callbacks like you have, you may have to pass in an empty array for the parameters. e.g.:

    transaction.executeSql(QueryExecute, [], successCB, errorCB);

    Referenced from the Cordova docs here: https://cordova.apache.org/docs/en/latest/cordova/storage/storage.html