1 Reply Latest reply on Sep 10, 2008 5:26 AM by 123qweads

    Strange problem with query for SQLite

    123qweads
      Hi!
      I've wasted a lot of time for a strange error...

      If I use a query like this
      myQuery:String = "UPDATE managment SET number= 2 WHERE id = 2 ";
      all works fine...

      but if I change the query in this way
      myQuery:String = "UPDATE managment SET number= 2 WHERE id > 1 ";
      I get this message: could not convert text value to numeric value

      Why???? id field type is INTEGER PRIMARY KEY...
      I've tried the same code with VB and work...

      Can you help me????
      thank you