SQlite database with PhoneGap and JavaScript

Question

I'm using PhoneGap and a SQLite Database.

I try something like this:

I have a function useSavedThing():

function useSavedThing() {

        alert("BEFORE getSavedThing()");    

    getSavedThing();

        alert("AFTER getSavedThing()");

}

and a function getSavedThing():

function getSavedThing(){

        alert("ONE");
        var db = window.openDatabase("Database", "1.0", "Database", 200000);
    db.transaction(populateDB, errorCB, successCB);
        alert("TWO");
    function populateDB(tx) {

        alert("THREE");
    }

    function errorCB(tx, err) {
        alert("Error processing SQL: " + err);
    }

    function successCB() {
        alert("FOUR");
        db.transaction(getData);
    }

    function getData(tx) {
                alert("FIVE");
        tx.executeSql('SELECT * FROM SETTINGS', [], getIt, errorCB);
    }
    function getIt(tx, results) {
                   alert("SIX");
            var savedthing = results.rows.item(0).data;


    }



}

The problem is that when the function getSavedThing() is called, only the first two alerts (alert("ONE"), alert("TWO)) issued but then the alert ("AFTER getSavedThing ()") called.

But I want that all expenses alert ("ONE"), alert ("TWO"), alert ("THREE") alert ("FOUR") alert ("FIVE"), alert ("SIX"), issued before the alert("AFTER getSavedThing()"); appers.

The order fo the alerts should be:

alert("BEFORE getSavedThing()");
alert("ONE");
alert("TWO");
alert("THREE");
alert("FOUR");
alert("FIVE");
alert("SIX");
alert("BEFORE getSavedThing()");

Can someone help me?

can you show us any output in firebug or similar? I assume the functions inside getSavedThing() should be outside of it. — 最白目
– 最白目, Commented Feb 1, 2013 at 11:40

pawel · Accepted Answer · 2013-02-01 12:12:10Z

1

Database operations are performed asynchronously. If you want alert("AFTER getSavedThing()") to be executed after the last database operation it needs to be called from the callback function getIt();

function useSavedThing() {
    alert("BEFORE getSavedThing()");
    var afterGet = function(){
        alert("AFTER getSavedThing()");
    }
    getSavedThing( afterGet ); /*pass the callback function to getSavedThing*/
}

function getSavedThing( callback ){

    alert("ONE");
    var db = window.openDatabase("Database", "1.0", "Database", 200000);
    db.transaction(populateDB, errorCB, successCB);
    alert("TWO");
    function populateDB(tx) {
        alert("THREE");
    }

    function errorCB(tx, err) {
        alert("Error processing SQL: " + err);
    }

    function successCB() {
        alert("FOUR");
        db.transaction(getData);
    }

    function getData(tx) {
        alert("FIVE");
        tx.executeSql('SELECT * FROM SETTINGS', [], getIt, errorCB);
    }

    function getIt(tx, results) {
         alert("SIX");
         var savedthing = results.rows.item(0).data;
         callback.call(); /*execute the callback function*/
    }
}

answered Feb 1, 2013 at 12:12

pawel

37.1k7 gold badges59 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

PMe Over a year ago

Thats it! This is why u use stackoverflow :-) Love it! Thank very much!

Leo Cai · Accepted Answer · 2013-02-02 14:51:12Z

0

You can use this framework for data access in PhoneGap, you will find it quite easy to use:

var db = new MyDB();
//query all users
var users = db.Users.toArrary(callback);

answered Feb 2, 2013 at 14:51

Leo Cai

6101 gold badge7 silver badges13 bronze badges

Collectives™ on Stack Overflow

SQlite database with PhoneGap and JavaScript

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related