SQLITE QUERY

[deveu]

I want to query in optimize way in a function
I need to retuen value
what is the wrong with this code

function get_lyl_member_max_id() {
db.transaction(function(tx) {
sql = "SELECT max(id) as mid FROM lyl_member ";
console.log(sql);
tx.executeSql(sql, [],function(tx, results) {
if (results.rows.length0)
{
var row = results.rows.item(0);
alert(row['mid']);
return row['mid'];
}
},errorHandler);

Code: Select all

             }); 

}

function errorHandler(tx, error)

{
alert('Oops. Error was ' + error.message + ' (Code ' + error.code + ')');
// Handle errors here

Code: Select all

 var we_think_this_error_is_fatal = true; 

 if (we_think_this_error_is_fatal) return true; 

 return false; 

}

[deveu]

function get_lyl_member_max_id() {
db.transaction(function(tx) {
sql = "SELECT MAX(id) as max_id FROM lyl_member";
tx.executeSql(sql, [],function(tx, results) {
if ( results.rows.length0)
{
var row = results.rows.item(0);
alert(row['max_id ']);
return row['max_id '];
}
});

Code: Select all

             }); 

}

what is the wrong with this query for max id

but

SELECT id FROM lyl_member

is working

[deveu]

db.transaction(function(tx)
{
var d = new Date();
var n = d.getTime()/1000;
id = get_lyl_member_max_id();

Code: Select all

       alert(id); 

       join_business_id = localStorage.getItem("local_business_id"); 

       sql = "INSERT INTO  lyl_member(id,join_business_id,m_number,status,time_join,flag)"+  
             " VALUES('"+id+"','"+join_business_id+"','"+m_number+"','active','"+ n  +"','1')"; 

             tx.executeSql(sql); 
});    

}

function get_lyl_member_max_id() {
maxid = "";
db.transaction(function(tx) {
sql = "SELECT id FROM lyl_member";
tx.executeSql(sql, [],function(tx, results) {
if ( results.rows.length0)
{
var row = results.rows.item(0);
alert(row['id']);
maxid = row['id'];
}
});

Code: Select all

             }); 
 return maxid; 

}

return value is always empty of get_lyl_member_max_id();
but inside sql query is ok
can you tell me why?

[deveu]

function get_lyl_member_max_id() {
maxid = "";
db.transaction(function(tx) {
sql = "SELECT max(id) AS maxid FROM lyl_member";
tx.executeSql(sql, [],function(tx, results) {
alert("length:"+results.rows.length);
if ( results.rows.length0)
{
var row = results.rows.item(0);
alert("data"+JSON.stringify(results.rows.item(0)));
maxid = row['maxid'];
}
});

Code: Select all

             }); 
 return maxid; 

}

we have data
but always getting maxid empty
let me know if you have idea

[Maryna Brodina]

Hello!

Could you clarify what exactly doesn't work?

Are there any errors or just empty result?

[deveu]

tx.executeSql is taking time to execute and returning empty value
How the function will wait until execute query and will return from resultset

[deveu]

can you send me a link of callback example
we need sync data

[deveu]

function is_lyl_member(m_number) {

Code: Select all

 db.transaction(function(tx) { 
     sql = "SELECT * FROM lyl_member WHERE   m_number='" + m_number + "'"; 
     tx.executeSql(sql, [], function(tx, results) { 

                 for (var i = 0; i < results.rows.length; i++) { 
                     var row = results.rows.item(i); 
                 } 

                 if (results.rows.length  0) { 
                     return true; 
                 } 
                 return false; 
     }); 

 }); 

}

return value id undefined
this function is returning before query execution

How may i solve this

[deveu]

Test at:
http://appery.io/app/view/d66d1341-58...

1. Click "login" button

2. Click "load mysql to sqlite" button

3. Click "Enter Check-in"

4. Enter phone "0412345678" and press "Check-in" button

   You will see empty alert "undefined"

[obullei]

Hello!

We are working on it.
I will let you know when have more information from developers team.