On 10 Apr 2013, at 1:01am, ven...@intouchmi.com wrote: > I am using sqlite3_column_type.
Okay. Note that that returns the type of a particular value: <http://www.sqlite.org/c3ref/column_blob.html> "information about a single column of the current result row of a query" In other words, as I wrote earlier it is information about one row. It does not necessarily apply to any other rows returned by the same query. And you can't just execute it on SELECT statement, you have to actually get a row of results and execute it on that row. > I'l try sqlite3_column_dectype tomorrow. Erm ... no such function. Unless you're getting it from somewhere I'm not looking. Can you show a URL ? > I'm hoping that the column type follows the intermediate result set from > joins and views. It looks like I have to be sure > SQLITE_ENABLE_COLUMN_METADATA is set. The result of calling 'sqlite3_column_type' should be the type of whatever value is stored or calculated. If the software putting values into the tables is consistent then the types you get out are consistent, but it's perfectly valid to do this: INSERT INTO myTable VALUES (NULL); INSERT INTO myTable VALUES (1); INSERT INTO myTable VALUES ('A'); Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
