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

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?

__________________
My blog, Inverted Keystrokes, is looking for aspiring developers (not necessarily with Android) to post articles. If you have any development experience and are interested in participating, please PM me. =)

junchronick

can I get the full codes?