topic What is the error message you in Software Archive

client SQL to control DB

paolo_c_ — Mon, 14 Dec 2015 14:17:25 GMT

Hi,

I have an error in my app wher I read DB.

Can I controll my DB with some client SQL? I find my DB in android device?

This is un exctract of my code

var db = openDatabase('mydb1', '1.0', 'Test DB', 2 * 1024 * 1024);
        var sCombo;
        var sComboSet;
        var sComboGioca;
        var partitaId = gPartitaAperta;

db.transaction(function (tx) {
var sql = 'SELECT p.nome FROM partita p WHERE p.id = ' + partitaId;

etc.....

What is the error message you

Rakshith_K_Intel — Mon, 14 Dec 2015 22:43:35 GMT

What is the error message you are seeing? and what android device/version are you using to test?

paolo_c_ — Tue, 15 Dec 2015 08:22:32 GMT

Android 4.4.2 but it is not important
Maybe I explained bad
I have errors due to data incorrectly inserted

I need a tool sql to access and control the data I recorded
I installed sql editor, but I do not know where to find my DB on the device

That's going to be tough. Did

PaulF_IntelCorp — Tue, 15 Dec 2015 15:15:04 GMT

That's going to be tough. Did you use the SQLite plugin to implement your SQL database? If so, you can inspect that plugin's source code to determine the name and location of the DB file and maybe extract that file from a device using something like Astro. Or, you might have to modify your app to retrieve and mail the DB file from your device. In any event, if you believe you have put bad data in the DB and you have the app installed on many devices, you'll probably have to issue a new version of the app that, on first run, reads the bad DB, fixes it, and stores the fixes back...