Simple Titanium SQLite sample

tisqlitesample.js

Ti.Database.install('/dbname.sqlite','dbname');
var mydb = Ti.Database.open('dbname');
	
var sql="SELECT ..... ";
var RS=mydb.execute(sql);
        
var data='';
while(RS.isValidRow()){
    data += RS.fieldByName('fieldname') + ' - ';
    RS.next();
}
        
RS.close();