Avatar

Community Advisor

Hi Mary,

you may use dbEngine class to work with sql queries from JS.

var dbEngine = instance.engine

dbEngine.exec("UPDATE your_table SET column = 1 WHERE 1=1")

Therefore, it is possible to use something like dbEngine.rollback() but not after the code above  because commit is done automatically. You have to write procedure in order to use commit or rollback after transaction.

Regards,

Milan