Handling return with SQL query?

Hello,

Code:

         String getLoc() {  
                String ret = "noloc";            
_sqLite.Query(Core.Database.Sql.Builder.Append("SELECT x,y,z FROM locations ORDER BY RANDOM() LIMIT 1;"), _sqLiteConnection, list =>
            {
                    foreach (var entry in list)
                    {
                      ret = (string)entry["x"] + "-" + (string)entry["y"] + "-" + (string)entry["z"];;                    
                      Puts(ret);
                    }
            });
            return ret;    
        }

why return is all time "noloc" but in puts is select from db?

 

Because SQL queries are concurrent.

 

How rework it?

 

By putting the logic that uses ret into the callback for the query.