Hi all,
I’m using expo-sqlite for implementing a local database on a android app.
How to perform sqlite rollback transaction with expo library or is there any other component?
I try to do transaction with this code:
const Deletequery = DELETE FROM   ;
const InsertQuery = INSERT into Talukalist(State_Code, District_Code, Taluka_Code, Taluka_Name) VALUES ${string};
const SeleteQuery = SELECT * FROM Talukalist;
db.transaction(
function (tx) {
tx.executeSql(
Deletequery,
,
(tx, results) => {
console.log(“TalukaDelete query result callback”);
},
(tx1, error) => {
console.log(“TalukaDelete query Error callback”, error.message);
return true;
}
);
tx.executeSql(
InsertQuery,
,
(tx, results) => {
console.log(“TalukaInsert query result callback”);
},
(tx1, error) => {
console.log(“TalukaInsert query Error callback”, error.message);
return true;
}
);
},
(error) => {
console.log("DB Transaction Error Message :- ", error.message);
return true;
},
() => {
//console.log(“Success”);
db.transaction(function (tx) {
tx.executeSql(SeleteQuery, , (tx, results) => {
console.log(“DB Transaction Select query Success callback”);
});
});
}
);