Error Processing Sql 1 Phonegap

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn error processing sql 5 phonegap more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags

Error Processing Sql Undefined Phonegap

Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you,

Error Processing Sql 0 Phonegap

helping each other. Join them; it only takes a minute: Sign up phoneGap Android - Populate database once “Error processing SQL:1” up vote 1 down vote favorite 2 I am trying to avoid populate the database if the database exists but when I try to cancel this line in my code I get "Error processing SQL:1" tx.executeSql('DROP TABLE IF EXISTS DEMO'); this is my whole populate function function populateDB(tx) { tx.executeSql('DROP TABLE IF EXISTS DEMO'); tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, word TEXT NOT NULL'); tx.executeSql('INSERT INTO DEMO (id, word) VALUES ("1", "Apple")'); tx.executeSql('INSERT INTO DEMO (id, word) VALUES ("2", "Orange")'); } android database cordova populate share|improve this question edited Jul 2 '12 at 2:47 asked Jun 8 '12 at 4:12 shoujo_sm 93442146 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote accepted Your function has set of issues which are corrected below. It should work now. function populateDB(tx) { isTableExists(tx, "DEMO", function(status) { if (!status) { alert("table not exist, creating one"); tx.executeSql('CREATE TABLE DEMO (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, kword TEXT NOT NULL, eword TEXT NOT NULL, pronoun TEXT NOT NULL, level INTEGER NOT NULL)'); tx.executeSql('INSERT INTO DEMO (kword, eword, pronoun, level) VALUES ("Apple", "", "", 1)'); tx.executeSql('INSERT INTO DEMO (kword, eword, pronoun, level) VALUES ("Orange", "", "", 2 )'); } else { alert("table exist, dropping for test"); tx.executeSql('DROP TABLE DEMO'); } }); } function isTableExists(tx, tableName, callback) { tx.executeSql('SELECT * FROM DEMO', [], function(tx, resultSet) { if (resultSet.rows.length <= 0) { callback(false); } else { callback(true); } }, function(err) { callback(false); }); } share|improve this answer edited Jul 2 '12 at 6:38 answered Jun 8 '12 at 6:00 dhaval 6,34922233 hi, I edited the question (some mistake when I write question for the SQL) when I left out the "id" from "INSERT INTO DEMO (id, word)" I get Error processing SQL:5. I am trying not to execute insert SQL if table DEMO exist. –shoujo_sm Jul 2 '12 at 2:57

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like http://stackoverflow.com/questions/10942971/phonegap-android-populate-database-once-error-processing-sql1 you, helping each other. Join them; it only takes a minute: Sign up Phonegap Sqlite Error processing SQL : 6 up vote 0 down vote favorite I'm French so sorry for my bad english, I need some help, I'm trying to copy my database on my webserver into my phonegap application for make a local database, so http://stackoverflow.com/questions/31386348/phonegap-sqlite-error-processing-sql-6 I've this : function dlDatabase(){ var db = window.openDatabase("Databases", "1.0", "Cordova Demo", 200000); db.transaction(createAllTables, errorCB, dlCountry); } function createAllTables(tx){ tx.executeSql('CREATE TABLE IF NOT EXISTS Country (id integer primary key, name text, nbQuestion integer)'); tx.executeSql('CREATE TABLE IF NOT EXISTS Question (id integer primary key, text text, CountryId integer)'); tx.executeSql('CREATE TABLE IF NOT EXISTS Answer (id integer primary key, QuestionId integer, text text, isGood boolean)'); } function insertCountry(tx, id, name, number){ tx.executeSql("INSERT INTO Country(id, name, nbQuestion) VALUES (?,?,?)", [id, name, number]); } function dlCountry() { alert("dlCountry"); $.ajax({ type: "POST", url: url, dataType: "json", data : { actionname : 'dlCountry' }, success: function(data) { arrayCountry = data.arrayCountry; var db = window.openDatabase("Databases", "1.0", "Cordova Demo", 200000); db.transaction(function(tx){ for (var i = 0; i < arrayCountry.length; i++) { alert(arrayCountry[i].id+" "+arrayCountry[i].name+" "+arrayCountry[i].number); insertCountry(tx, arrayCountry[i].id, arrayCountry[i].name, arrayCountry[i].number); }; }, errorCB, dlQuestion); }, error: function(data) { alert("error !"); } }); } I call the dlDatabase function when i login, that's work, but, after insert all the countries ( after the alert ), I've an error cod

here for a quick overview of the site http://stackoverflow.com/questions/25442653/having-an-error-processing-sql0-phonegap-sql Help Center Detailed answers to any questions you might have https://cordova.apache.org/docs/en/1.5.0/phonegap/storage/sqltransaction/sqltransaction.html Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges error processing Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Having an Error processing SQL:0 PhoneGap SQL up vote 0 down vote favorite error processing sql I created an android app using html5 and phonegap and I have a problem in inserting data into database.. this is my code document.addEventListener("deviceready", onDeviceReady(), false); var db; function onDeviceReady(){ db = window.openDatabase("Libsys", "2.0", "LibraryDB", 200000); //will create database Dummy_DB or open it db.transaction(populateDB, errorCB, successCB); } function populateDB(tx) { tx.executeSql('CREATE TABLE IF NOT EXISTS Borrowinfo(id INTEGER PRIMARY KEY AUTOINCREMENT, IDno TEXT NOT NULL, Name TEXT NOT NULL, course TEXT NOT NULL, author TEXT NOT NULL, title TEXT NOT NULL, date_start TEXT NOT NULL, date_return TEXT NOT NULL)'); } function queryDB(tx){ tx.executeSql('SELECT * FROM Borrowinfo', [], querySuccess, errorCB); } function querySuccess(tx,results){ var len = results.rows.length; for (var i = 0; i < len; i++) { var row = results.rows.item(i); $("#Lists").append("