B4A Tutorial SQL tutorial - Erel    Oct 2, 2019   (19 reactions)   tags: sqliteimages, begin transaction, SQL .BeginTransaction
Try
For i = 1 To 500
SQL1.ExecNonQuery2("INSERT INTO table1 VALUES ('def', ?, ?)", Array As Object(i, i))
Next
SQL1.TransactionSuccessful
Catch
Log(LastException.Message)
End Try
SQL1.EndTransaction
End Sub
This code... the transaction block should usually look like:
SQL1.BeginTransaction
Try
'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... B4A Question java.sql.SQLException: Could not retrieve transaction read-only status from server - aeric (first post)    Oct 20, 2023 Is the server running on new version of MySQL?
Please post your jdbcUrl and the whole error message.
Check this post:
https://www.b4x.com/android/forum/threads/jdbcsql-insert-error.133527/... 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 SQL: Asynchronous NonQuery Transaction Routine - Mahares    Jan 15, 2013 I have introduced below correct?
'SQL1.BeginTransaction
'Try
For i = 1 To 10000 ...)))
Next
sql1.ExecNonQueryBatch("SQL")
'SQL1.TransactionSuccessful
'Catch ... 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.... 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")
SQL_Write_Data
End Sub... 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)... Page: 1   2   3   4   5   6   7   |