[android-developers] Re: SQLite query problems

2010-05-28 Thread JMichel
Thanks for the answer. But for your information the item is not a float nor a double. It is a reference to an integer defined like this: item REFERENCES tbl_items(_id)); where _id is the primary key of another table defined as: _id INTEGER PRIMARY KEY AUTOINCREMENT, So I'll follow your tip

[android-developers] Re: SQLite query problems

2010-05-27 Thread Nathan
I have experienced the same thing. I'm guessing that item is a float or double, right? The SQLiteDatabase class doesn't handle floating point properly in this call. I've had to resort to version 2 in all my calls. Although this doesn't work properly, I'm not sure it would be considered a bug