B b4auser1 Well-Known Member Licensed User Longtime User Jan 26, 2014 #1 How to check, if there is an active transaction in SQLite ?
Erel B4X founder Staff member Licensed User Longtime User Jan 27, 2014 #2 The transactions are started in your code. You can add a flag (global variable) to mark the beginning of a transaction. There is no way to find it from the SQL object. Upvote 0
The transactions are started in your code. You can add a flag (global variable) to mark the beginning of a transaction. There is no way to find it from the SQL object.
K keirS Well-Known Member Licensed User Longtime User Jan 27, 2014 #3 You can do this using the reflection library I think. Code: Copy Dim SQL1 As SQL Dim R As Reflector Dim inTransaction As Boolean R.Target = SQL1 R.Target = R.GetField("db") inTransaction = R.RunMethod("inTransaction") Log(inTransaction) Upvote 0
You can do this using the reflection library I think. Code: Copy Dim SQL1 As SQL Dim R As Reflector Dim inTransaction As Boolean R.Target = SQL1 R.Target = R.GetField("db") inTransaction = R.RunMethod("inTransaction") Log(inTransaction)
mc73 Well-Known Member Licensed User Longtime User Jan 27, 2014 #4 If you're using begin and end transaction, you can easily use a flag as erel suggested, and setting it to true at begin, and false after end. Upvote 0
If you're using begin and end transaction, you can easily use a flag as erel suggested, and setting it to true at begin, and false after end.
