Search Results

EndTransaction appartiene alla versione per B4A Klaus was quicker than me :) SQL1.BeginTransaction Try <blah blah> SQL1.TransactionSuccessful Catch Log(LastException.Message) #If B4i OR B4J SQL1.Rollback #END IF End Try #If B4A SQL
link: Basta confrontare gli esempi (e copiarne-incollarne il codice) di BeginTransaction nei due linguaggi. Dovrebbe essere così: SQl1.BeginTransaction
link: Just for information. SQL.EndTransaction does exist in B4A but not in B4i and B4J.
link: Ok, scoperto l'arcano per il post Unknown member: endtransaction (mea ignorantia). Ma qual è l'arcano di questo codice (che nella mia testa è SQLite

Probably clearer by the code example at: https://www.b4x.com/android/help/sql.html#sql_begintransaction SQL1.BeginTransaction Try 'block of statements like: For i = 1 to 1000 SQL1.ExecNonQuery("INSERT INTO table1 VALUES(...) Next SQL1.TransactionSuccessful Catch Log(LastException.Mess
link: Hi everyone after TransactionSuccessful every thing is ok but when reopen app i see data the same before update Main.SQL1.BeginTransaction Try
link: Where is the .EndTransaction? https://www.b4x.com/android/help/sql.html#sql_transactionsuccessful Marks the transaction as a successful transaction.

It just requires an additional call at the right place: sql.ExecNonQuery("COMMIT;") See: (Thanks to @jmon https://www.b4x.-and-ucanaccess.62909/post-477390 https://www.b4x.-with-ucanaccess-not-committing-inserts-solved.96142/post-606832
link: I spent quite a bit of time tracking down an error that... wasn't in my project. To prevent you from doing it too... I had to insert many records int

Hey Domingo: You do something like this; SQL1.BeginTransaction Try 'Execute the sql statements or the NON Query statements: DELETE/UPDATE/INSERT. SQL1.TransactionSuccessful Catch 'the transaction will be cancelled Log(LastException.Message) End Try SQL1.EndTransaction

The above code took less than half a second to run on a real device. Without the BeginTransaction / EndTransaction block it took about 70 seconds. A transaction block can also be used to guarantee that a set of changes were successfully done. Either all changes are made or none are made. By calling
link: Here is the new code, and it fixed the problem. sql1.BeginTransaction Try For a =0 To liste_cartes.Size-1 carte=liste_cartes.Get(a) liste_arg.Clea
link: When "BeginTransaction / EndTransaction" is used as the DB is blocked, record-level, table-level or database-level ??

Or this code: Sub Button1_Click Dim SQL2 As SQL SQL2.Initialize(DBFileDir,DBFileName,True) Log("0") Msgbox("0","") SQL2.ExecNonQuery("Delete From masclis") Log("1") Msgbox("1","") SQL2.BeginTransaction Try For wI=0 To 30000 SQL2.Exec
link: Sometimes it is better and safer to use parameterized query. So instead of: SQL2.AddNonQueryToBatch("Insert Into masclis (codigo,nombre,nif,direccion,

if it fails via try catch SQL1.BeginTransaction Try 'block of statements like: For i = 1 to 1000 SQL1.ExecNonQuery("INSERT INTO table1 VALUES(...) Next SQL1.TransactionSuccessful Catch Log(LastException.Message) 'no changes will be made End Try SQL1.EndTransaction https://www.b4x.com/a

sql.BeginTransaction sSQL = "UPDATE .dbo.devices_hello " & _ "SET " & _ "active_user = '', " & _ "active = 0, " & _ "last_user = '" & pubID & "', " & _ "last_u
link: Close End Sub Sub update_ttl Dim rs As ResultSet, sSQL As String Dim valid As Boolean valid = True ' // get a SQL connec

For offline Create a new table in the database called user, then from b4j Dim Sql1 As SQL Sql1.InitializeSQLite(File.DirApp, "mydb.db" , False) 'insert to DB Main.Sql1.BeginTransaction Try /// my db > user > id,name,pass,date Main.Sql1.ExecNonQuery2("INSERT

At first, I pulled those lines out and ran the appropriate command: if cmd = "BEGIN TRANSACTION;" then sql1.BeginTransaction and same for commit. But then I figured there was no reason to do that to properly transacted SQL. @Erel , let me know if having the BEGIN TRANSACTION; and COMMIT; in
link: @Erel you are rigth, but when export schema from "DB Browser" sql file is like this: BEGIN TRANSACTION; CREATE TABLE IF NOT EXISTS "demo" ( "id"
link: Append(next_char) End If i=i+1 Loop End If Return cmdList End Sub 'here is an example function making use of

Powered by ColBERT