Update has no effect on database

[dwome]

Hello,

I am trying to update some values in my database, but the transaction shows no effect. Do you have an idea what I am doing wrong here?

var con = fb.createConnection();
con.connectSync('pwrhsb.gdb'), 'SYSDBA', 'masterkey', '');
const query = 'UPDATE OBJEKT SET BEZ = 'ABCDEFG' WHERE OB_KEY = 25984';

const transaction = con.startNewTransactionSync();
const result = transaction.prepareSync(query);

result.execInTransSync(transaction);
transaction.commitSync();

[miiguelperes]

I have same problem

[miiguelperes]

In my case I was not doing the commit or the disconect, this way it worked:

return new Promise((resolve, reject) => {
var conn = fb.createConnection();
conn.connect(self.configuracoes.database,self.configuracoes.user,self.configuracoes.password,'',function(err){
if(self.reportError(err, query)) reject(err) ;
conn.query(query, function(err,qres){
if(self.reportError(err, query)) reject(err) ;
let obj = qres.fetchSync('all',true)
conn.commit(function(err){
console.log("Commit done ", err);
});
conn.disconnect();
resolve(obj)
});
});
conn.on('error',function(error){
reject(error)
console.log(error)
});

});