PureBasic Forums - English

Code: Select all

function onNext(rec) {
    console.log(rec);
}

function onFieldData(fld) {
    console.log(fld);
}

function onError(msg) {
    console.log(msg);
}

window.onload = function() {
    sb_database.onNext.connect(onNext); //sb_database is the object I injected
    sb_database.onError.connect(onError);
    sb_database.onFieldData.connect(onFieldData);
    var db = sb_database.connect(0,"mydb.sdb","",""); // 0 = SQLite, 1 = ODBC
    if(db==0) { return; }
    if(sb_database.begin(db)!=1) { return; }
    var params = ["United Kingdom"];
    var jsparams = JSON.stringify(params);
    var rs = sb_database.select(db,"SELECT * FROM COUNTRIES WHERE COUNTRY=?",jsparams);
    if(rs==0) { return; }
    while(sb_database.moveNext(rs)==1) {
        // handled by callbacks...
    }
    sb_database.commit(db);
    sb_database.freeQuery(rs);
    if(sb_database.begin(db)!=1) { return; }
    params = ["No","United Kingdom"];
    jsparams = JSON.stringify(params);
    if(sb_database.execute(db,"UPDATE COUNTRIES SET IS_EU=? WHERE COUNTRY=?",jsparams)!=1) { return; }
    if(sb_database.commit(db)!=1) { return; }
    sb_database.close(db);
    console.log("done");
}

window.onunload = function() {
    sb_database.onNext.disconnect(onNext);
    sb_database.onError.disconnect(onError);
}