On 13 Oct 2011, at 5:48pm, Frank Missel wrote: > "The problem is the typelessness of SQLite. In order to obtain column > information early, a SELECT is prepared twice. The first gives the column > names and potential type information. > > In the second phase the second select retrieves data. For computed columns, > SQLite usually reports SQLITE_TEXT or even SQLITE_NULL in > sqlite3_column_type. As long as an ODBC application retrieves in advance the > correct typed values of a rowset, everything is fine. But that seems not to > be the case for Excel/Query."
would something like SELECT CAST (theValue AS REAL) AS thisValueReal FROM ... force the driver to recognise that the value it was getting was REAL ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
