issue with get array values outside the function in javascript?

Question

I have created an array which will store dynamic values coming from DB. When I print the array inside the transaction function it is printing. when I tried to print out side I didn't get the values. I have declared the array globally. what is the problem, my code is as follows;

function sendCategoryDetails() {

    var selected_category = $('#select-choice :selected').val();
    alert("control : " + selected_category);
    var mycoodinatesDetails;
    var myLocation = new Array();
    var db = window.sqlitePlugin.openDatabase({name: "MYDB"});

    db.transaction(function (tx) {
        tx.executeSql("select Location from Locationlog WHERE Category = '"+selected_category+"';", [], 
            function (tx, res) {
                for (var i = 0; i < res.rows.length; i++) {
                    myLocation[i] = res.rows.item(i).Location;
                }
                alert (myLocation +" length : "+ myLocation.length); // Values are printing 
            });
    });
    alert (myLocation +" length : "+ myLocation.length); // values are not getting, It showing the length is 0
}

Any suggestions?

Welcome to the world of Async calls.

Satpal
– Satpal

2014-04-21 13:06:01 +00:00
Commented Apr 21, 2014 at 13:06 — Satpal
– Satpal, Commented Apr 21, 2014 at 13:06

tymeJV · Accepted Answer · 2014-04-21 13:06:22Z

4

tx.executeSql is an async function. The alert works within the function since that is the callback and the async processing has finished. The alert after the function is trigger before the function has finished, thus being undefined.

Solution: Do the work inside the callback or call another function with the array passed as a parameter and do the work there.

answered Apr 21, 2014 at 13:06

tymeJV

105k14 gold badges165 silver badges158 bronze badges

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

2 Comments

Vinod Over a year ago

Is it possible to write tx.executeSql inside another tx.executeSql ? I ant to write query for array elements. How can I do that ?

tymeJV Over a year ago

You can write another execute within the callback.

Collectives™ on Stack Overflow

issue with get array values outside the function in javascript?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related