Android Question [SOLVED] SQL Result

[makis_best]

If I execute one SQL statement like

SQL1 = $"DELETE FROM LOCAL_Trade WHERE Code = '${OrdersTable.GetValue(1, RowX)}'"$

No mater if the condition apply or not the command it will executed and it will complete successfully and the result will be true.

How I can know that delete actually is made.

Thank you.

 

[LucaMs]

Execute an equivalent SELECT, after

 

[RB Smissaert]

If I execute one SQL statement like

SQL1 = $"DELETE FROM LOCAL_Trade WHERE Code = '${OrdersTable.GetValue(1, RowX)}'"$

No mater if the condition apply or not the command it will executed and it will complete successfully and the result will be true.

How I can know that delete actually is made.

Thank you.

Sub GetNumberOfChanges() As Long
 Dim strSQL As String
 Dim lRows As String
 strSQL = "SELECT changes()"
 lRows = SQL1.ExecQuerySingleResult(strSQL)
 Return lRows
End Sub

RBS

 

[MarkusR]

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/android/help/sql.html#sql_begintransaction

 

[makis_best]

I was thinking if there was a quicker way than executing before and after select count()

 

[RB Smissaert]

I was thinking if there was a quicker way than executing before and after select count()

The code I posted is very fast as it doesn't need to count. Also bear in mind that counting won't work if it is an update.

RBS

 

[makis_best]

@RB Smissaert thank you for your reply.

Very nice solution... Working like the @@ROWCOUNT of SQL Server.
Perfect.