I have an array
//[Paid, balance]
let tableData = [txtNewAmount.value,(select balance from table1 order by id DESC) + txtNewAmount.value]
var stmt = db.prepare(`INSERT INTO ${SaveToDb.tableName} (Paid, Balance) VALUES (?, ?))
stmt.run(sqlValue)
The query is inserting data into database, but the problem is , it is saving "Balance" column saving full select query as string instead of total value "(select balance from table1 order by id DESC)
I want save it as input value(10) + paid(10) = 20
can anybody help me
Let me know if you know if any other way to save this logic
Use INSERT INTO tablename SELECT ...
let stmt = db.prepare(`
INSERT INTO ${SaveToDb.tableName} (Paid, Balance)
SELECT ?, balance + ?
FROM table1
ORDER BY id DESC`);
stmt.run([txtNewAmount.value, txtNewAmount.value]);