When I try and read a TIMESTAMP field from an Apple created Sqlite file I get
"Error querying database: Invalid format string". I haven't given it a
format string. I can read other fields, but it chokes on fields of type
TIMESTAMP. Here's some code:
using (SqliteDataReader dbReader = sqlCom.ExecuteReader())
{
if (dbReader.HasRows)
{
while (dbReader.Read())
{
string myFile = Convert.ToString (dbReader["FILENAME"]); //
this works
string myDate = Convert.ToString (dbReader["DATECREATED"]); //
this fails
-------------------------
I think dbReader["fieldName"] is returning type OBJECT, so it shouldn't
really be complaining about "format string".
If this is a bug, does anyone know a work-around, i.e. a different query
command that isn't so picky?
Thanks,
Jim G.
--
View this message in context:
http://monotouch.2284126.n4.nabble.com/Does-MonoTouch-s-Sqlite-support-TIMESTAMP-93-data-type-tp4439834p4439834.html
Sent from the MonoTouch mailing list archive at Nabble.com.
_______________________________________________
MonoTouch mailing list
[email protected]
http://lists.ximian.com/mailman/listinfo/monotouch
