How to delete from SQLite


Last Updated:

  1. hno2005

    hno2005 Member This Topic's Starter

    Joined:
    Jul 2, 2012
    Messages:
    13
    Likes Received:
    0
    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
     

    Advertisement
  2. mills2533

    mills2533 Well-Known Member

    Joined:
    Dec 21, 2010
    Messages:
    150
    Likes Received:
    22
    Isn't that the same as:

    DELETE FROM tbl1 WHERE cat=21
     
  3. jonbonazza

    jonbonazza Well-Known Member

    Joined:
    Jul 13, 2010
    Messages:
    1,934
    Likes Received:
    458
    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

    Joined:
    Apr 18, 2013
    Messages:
    3
    Likes Received:
    1
    can I get the full codes?
     

Share This Page

Loading...