How to delete from SQLite

Last Updated:

  1. hno2005

    hno2005 Member

    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 ?


  2. mills2533

    mills2533 Well-Known Member

    Isn't that the same as:

    DELETE FROM tbl1 WHERE cat=21
  3. jonbonazza

    jonbonazza Well-Known Member

    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?
  4. junchronick

    junchronick New Member

    can I get the full codes?

Share This Page