Hi -- I'm attempting to DELETE a row in a simple query, however I can't db.commit(query); because it doesn't exist with sql.js seemingly? It takes the query just fine but obviously it's never committed for the changes.
Any ideas / work arounds used by other people?
Thanks
initSqlJs().then(function (SQL) {
const db = new SQL.Database(dbFile);
const res = db.exec(query);
const modified = db.getRowsModified(query);
// db.commit(query); This doesn't exist...
console.log(res); // shows a blank array []
console.log(modified); // Shows the amount of "modified" rows
resolve(res);
db.close();
});
Hi -- I'm attempting to DELETE a row in a simple query, however I can't
db.commit(query);because it doesn't exist withsql.jsseemingly? It takes the query just fine but obviously it's never committed for the changes.Any ideas / work arounds used by other people?
Thanks