Android Question ExecQueryAsync and DELETE ... IN (1, 2, 3) not working?

[Jeffrey Cameron]

Using the new ExecQueryAsync method I execute the following SQL statement (AuditNum is an INTEGER column):

DELETE FROM [MyTable] WHERE [AuditNum] IN (1, 2, 3);

The method executes without error, however the rows are not actually removed from the database. When I use the same exact SQL statement with the ExecNonQuery method it behaves as expected and removes the correct rows from the database.

Is this by design or did I overlook an ExecNonQueryAsync method somewhere?

 

[DonManfred]

Is this by design

By design

Delete does not have an resultset. So using ExecQueryAsync will not work. You need to use ExecnonQuery

 

[Mahares]

I think the proper code for you should be:

SQL1.AddNonQueryToBatch("DELETE FROM [MyTable] WHERE [AuditNum] IN (?,?,?)", Array As Int (1,2,3) )
    Dim SenderFilter As Object = SQL1.ExecNonQueryBatch("SQL")
    Wait For (SenderFilter) SQL_NonQueryComplete (SuccessD As Boolean)
    If SuccessD Then
        Log("Deleted records in table: " & SuccessD)
    End If

 

[Jeffrey Cameron]

Thank you @DonManfred and @Mahares, I'll adjust accordingly.