B4A Tutorial SQL tutorial - Erel    Oct 2, 2019   (18 reactions)   tags: sqliteimages, begin transaction, SQL
For i = 1 To 500
SQL1.ExecNonQuery2("INSERT INTO table1 VALUES ('def', ?, ?)", Array As Object(i, i))
This code... the transaction block should usually look like:
'Execute the sql...
B4A Question JRDC2 MySQL Begin Transaction, Commit, Rollback - zabayin (first post)    Oct 21, 2020
Why not? It will create a single transaction for the commands and will rollback and changes if there is an error.
OOPS! seems I'm misunderstanding about single transaction can't be rollback and changes in database. thank you very much....
Italian SQL1.EndTransaction - Elric (first post)    Dec 8, 2021
remoto ha MySql, la app utilizza Sqlite.
Intendevo esattamente questo. Così ha senso inserire 1000...
B4J Question Rollback method has replaced EndTransaction for SQL Class - j_o_h_n    Mar 7, 2021
tl,dr 1: In the SQL class, the Rollback method has replaced EndTransaction. 2: BeginTransaction does not always begin a new Transaction. When I was looking at SQL examples here I came across some that made use of the EndTransaction method However this method no longer exists for the SQL... unparameterised data caused an exception: Sub Timer1_tick() Try SQL1.BeginTransaction... SQL1.TransactionSuccessful Catch 'I should have had SQL1.Rollback here to...
B4J Question jSQL - How to set TransactionIsolation - Erel (first post)    Sep 3, 2020
Dim connection As JavaObject = SQL1
connection = connection.GetField("connection")
connection.RunMethod("setTransactionIsolation", Array(2)) 'TRANSACTION_READ_COMMITTED...
B4A Question Problem Database "Malformed" on some tables. - vecino    May 13, 2021
I'm having trouble making a copy of the BD to save. First I close the DB, then I do a file.Copy finally I open the DB. SQL.Close, close pending transactions, if any? Is there a command to check if there are pending transactions and be able to execute them? Something like: if SQL.INTRANSACTION Then. SQL.TRANSACTION.CLOSE I do not know if I should also save the file -Journal of the database. Can you orient myself with this topic? Thanks....
B4A Question SQL: Asynchronous NonQuery Transaction Routine - Mahares    Jan 15, 2013
I have introduced below correct?
For i = 1 To 10000
B4J Question SQL BeginTransaction...TransactionSuccessful - cyiwin (first post)    Sep 11, 2014   (2 reactions)
I wanted to post a basic Batch SQL example in case anyone needs...
#Region Project Attributes..., "jdbc:mysql://serversite/site", "user", "pword")
B4J Question [SOLVED] SQL questions re: INSERT IGNORE, and EndTransaction - Daestrum (first post)    Oct 6, 2019   (2 reactions)
Its INSERT OR IGNORE, not INSERT IGNORE. (for SQLite, MySQL may accept INSERT IGNORE)...
B4J Question Unknown member: endtransaction - j_o_h_n    Jan 21, 2021
Has EndTransaction been removed from Connection class?
Dim sql1 As SQL = Main.pool.GetConnection
SQL1.BeginTransaction 'no problem , BeginTransaction appears in code completion drop down menu...
Page: 1   2   3   4   5   6   7