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

Jeffrey Cameron

Well-Known Member
Licensed User
Longtime User
Using the new ExecQueryAsync method I execute the following SQL statement (AuditNum is an INTEGER column):
B4X: 
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?
 
Sort by date Sort by votes
M

Mahares

Expert
Licensed User
Longtime User
I think the proper code for you should be:
B4X: 
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
 
Upvote 0
You must log in or register to reply here.

Similar Threads

P
  • Question
Android Question Deleted SQL records are not Actually Deleted
Replies
12
Views
224
Pelky
P
  • Question
Android Question SQLITE/SQLCipher
Replies
10
Views
579
aeric
B
  • Question
Android Question Deleting the records from the Master Table in SQLLite does not delete the records from the Transaction table despite the presence of Foreign Key - reg
Replies
6
Views
1K
beelze69
B
  • Question
Android Question (SOLVED) Problem with UPDATE-DELETE and WHERE / AND SQL operators
Replies
6
Views
1K
Mahares
M
  • Question
Android Question SQLLiteLight2 example SOLVED
Replies
3
Views
2K
Roger Daley
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…