GlobalVariableProblem

//global variable
var id=[];

//declare a promise to handle this treatement
//would be nice to call the same code many times
//use it as a function
Task.spawn(function* () {
    let db = yield Sqlite.openConnection({ path: myPath});

    try {
        let row = yield db.execute(
            "SELECT id FROM 'plates'");
        
        for ( i=0; i < row.length; i++) {
            console.log("row["+ i +"] :" + row[i].getResultByIndex(0));
            id.push(row[i].getResultByIndex(0));
        }
    }
    finally {
        yield db.close();
    }    
});

console.log("id length:"+id.length);
for (i=0; i<id.length; i++)
    console.log(i+" "+id[i]);