Has EndTransaction been removed from Connection class?
B4X:
Dim sql1 As SQL = Main.pool.GetConnection
SQL1.BeginTransaction 'no problem , BeginTransaction appears in code completion drop down menu
Try
'Execute the sql statements.
SQL1.TransactionSuccessful 'no problem , TransactionSuccessful appears in menu
Catch
'the transaction will be cancelled
End Try
SQL1.EndTransaction 'EndTransaction does not appear in menu and gives warning "unknown member: endtransaction" if you add it manually