I've been given the task of creating an adapter for our software to read existing SQLite/spatialite data tables. I am using the latest version of SQLite.net, which I obtained from the precompiled x86 binaries for .NET 4.0. When our code tries to execute "SELECT * FROM <tablename> ORDER by <tablename>.id", I get the exception "String was not recognized as a valid DateTime".
The underlying table has three columns that store datetimes, all of type text. Our infrastructure first creates an empty datatable based on the database schema using DataAdapter.FillSchema(p_data_table, SchemaType.Source) The data adapter has the SELECT command set on it, then is populated using DataAdapter.Fill(p_data_table); I've even tried modifying the code to change all DateTime columns in the DataTable to type String before the SELECT is executed, but it continues to complain about invalid DateTimes. I've seen many posts elsewhere on this, but no answers that work. Any help would be greatly appreciated. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users