On 22 May 2013, at 5:47pm, "Kevin Keigwin" <[email protected]> wrote:
> 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". Use your code to populate your database but don't worry about a SELECT command. Download the sqlite3 shell tool and try some select commands for the your database in that. Try something simple with a fixed tablename like SELECT * FROM myTable Does it work ? Can you prove that your code is correctly executing any statement at all ? > 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. SQLite doesn't have a DateTime type. If you are using some sort of library which does type testing and produces an error if the value is of the wrong type, it will always produce an error message when checking for DateTime. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
