Android Question [SOLVED] SQL Result

makis_best said:

If I execute one SQL statement like

B4X:

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.

Click to expand...

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

makis_best said:

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

Click to expand...