On 16 Sep 2009, at 6:05pm, vbshar wrote: > I think the problem is in field format ou data format, because if i > insert > data from my app SQLite does not return any value, but if i insert > data with > the manager "SQLite developer"; the query works...
Your definition >> BIRTH à DATETIME just creates a NUMERIC field, not a field with a type of DATETIME. Or at least that's what I understand from section 2.1 of http://www.sqlite.org/datatype3.html SQLite does not use string typing for its table contents. You might define a column as INTEGER but you can still insert a text value into it. Make sure that you are distinguishing between the integer value and the text value when you INSERT the row, as well as when you try to SELECT the row. Many management tools get this wrong: some assume that all values are text values, and some assume that any value which contains just digits can never be a text value. It might help if you use the sqlite3 command-line tool to insert a few records and perform a SELECT, and see if you get the same results as your management tool gets. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
