Apps How to delete from SQLite

[hno2005]

Hi every one
i want to run a delete query with limitation .
I've tried to many queries but they didn't work .
For know , I just want to remove all the rows and I write this code "

DELETE FROM tbl1 where _id IN(select _id from tbl1 WHERE cat=21)

The emulator runs perfectly without any error .
right now , I have 32 rows with cat = 21 .

could you help me to solve this problem ?

Thanks

 

[mills2533]

Isn't that the same as:

DELETE FROM tbl1 WHERE cat=21

 

[jonbonazza]

Isn't that the same as:

DELETE FROM tbl1 WHERE cat=21

Yes, this query is the same and also much cleaner than the OP's query.

As for why it is not working on the device, but does on the emulator, it's hard to tell with the given information. Do you receive an exception? An SQL Error code? Both?

 

[junchronick]

can I get the full codes?