updating in a transaction has no effect

[sqllyw]

Hi,

I have some code as following, if I use the connection object's prepareSync, it works, but if I startNewTransaction, the update did not happen in the database, any idea? Thanks.

var fb  = require("firebird");
sys = require("sys"); 
var con = fb.createConnection();
con.connectSync("10.114.173.149://opt/firebird/examples/employee.fdb", 'sysdba', 'masterkey', '');

var sql = `update country set currency = 'Lira9' where country = 'Italy'`

// working code
const result = con.prepareSync(sql );
result.execSync()
con.commitSync()

/* not working
con.startNewTransaction( (err, tx) => {

    const result = tx.prepareSync(sql );
    result.execSync()
    tx.commitSync()

})*/

[sqllyw]

if con.disconnect(), it works, but the code is used in a web app, and con.disconnect after every update does not seems a good approach

con.startNewTransaction( (err, tx) => {

    const result = tx.prepareSync(sql );
    result.execSync()
    tx.commitSync()
    con.disconnect()  // adding this works
})

[xdenser]

See execInTransSync/execInTrans

[sqllyw]

execInTransSync works, thanks