Phonegap Error Processing Sql 0

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 http://stackoverflow.com/questions/25442653/having-an-error-processing-sql0-phonegap-sql the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like 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 http://stackoverflow.com/questions/31386348/phonegap-sqlite-error-processing-sql-6 need some help, I'm trying to copy my database on my webserver into my phonegap application for make a local database, so 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

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 http://stackoverflow.com/questions/13689006/how-to-show-useful-error-messages-from-a-database-error-callback-in-phonegap about Stack Overflow the company Business Learn more about hiring developers or posting https://cordova.apache.org/docs/en/1.5.0/phonegap/storage/sqltransaction/sqltransaction.html 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 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up How to show useful error messages from a database error callback error processing in Phonegap? up vote 6 down vote favorite 2 Using Phonegap you can set a function to be called back if the whole database transaction or the individual SQL statement errors. I'd like to know how to get more information about the error. I have one generic error-handling function, and lots of different SELECTs or INSERTs that may trigger it. How can I tell which one was at fault? error processing sql It is not always obvious from the error message. My code so far is... function get_rows(tx) { tx.executeSql("SELECT * FROM Blah", [], lovely_success, statement_error); } function add_row(tx) { tx.executeSql("INSERT INTO Blah (1, 2, 3)", [], carry_on, statement_error); } function statement_error(tx, error) { alert(error.code + ' / ' + error.message); } From various examples I see the error callback will be passed a transaction object and an error object. I read that .code can have the following values: UNKNOWN_ERR = 0 DATABASE_ERR = 1 VERSION_ERR = 2 TOO_LARGE_ERR = 3 QUOTA_ERR = 4 SYNTAX_ERR = 5 CONSTRAINT_ERR = 6 TIMEOUT_ERR = 7 Are there any other properties/methods of the error object? What are the properties/methods of the transaction object at this point? I can't seem to find a good online reference for this. Certainly not on the Phonegap website! database cordova error-handling share|improve this question asked Dec 3 '12 at 17:58 Magnus Smith 2,83142748 add a comment| 2 Answers 2 active oldest votes up vote 9 down vote +50 http://docs.phonegap.com/en/2.2.0/cordova_storage_storage.md.html#SQLError The SQLError object is thrown when an error occurs when manipulating a database. This object has two properties: code (one of your described constants) message: A description of the error. So in your code error.mess

Capture Compass Connection Contacts Device Events File Geolocation Media Notification Storage Getting Started Guides Edit Source on GitHub English Deutsch English Español Français Italiano 日本語 한국어 Polski Русский Slovene 简体中文 繁體中文 1.5.0 dev 6.x (Latest) 5.4.0 5.1.1 5.0.0 4.0.0 3.6.0 3.5.0 3.4.0 3.3.0 3.2.0 3.1.0 3.0.0 2.9.0 2.8.0 2.7.0 2.6.0 2.5.0 2.4.0 2.3.0 2.2.0 2.1.0 2.0.0 1.9.0 1.8.1 1.8.0 1.7.0 1.6.1 1.6.0 1.5.0 × This version of the documentation is outdated! Click here for the latest released version. SQLTransaction Contains methods that allow the user to execute SQL statements against the Database. Methods executeSql: executes a SQL statement Details When you call a Database objects transaction method it's callback methods will be called with a SQLTransaction object. The user can build up a database transaction by calling the executeSql method multiple times. Supported Platforms Android BlackBerry WebWorks (OS 6.0 and higher) iPhone Execute SQL Quick Example function populateDB(tx) { tx.executeSql('DROP TABLE IF EXISTS DEMO'); tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)'); tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")'); tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")'); } function errorCB(err) { alert("Error processing SQL: "+err); } function successCB() { alert("success!"); } var db = window.openDatabase("[Database](../database/database.html)", "1.0", "PhoneGap Demo", 200000); db.transaction(populateDB, errorCB, successCB); Full Example