On 4/9/2013 9:09 PM, Simon Slavin wrote:
On 10 Apr 2013, at 1:19am, ven...@intouchmi.com wrote:
Yes, I called sqlite3_column_type before and after each sqlite3_step in order
to determine when it might work and it always came back as SQLITE_NULL (5).
Does that column correspond to an actual column in a table ? Or is it instead
the result of a calculation ? The documentation
<http://www.sqlite.org/c3ref/column_blob.html>
says "The value returned by sqlite3_column_type() is only meaningful if no type
conversions have occurred as described below. After a type conversion, the value returned
by sqlite3_column_type() is undefined."
"Type conversion" in that article has nothing to do with whether a
column is the result of a calculation, and everything to do with
retrieving the value by means of sqlite3_column_T call where T doesn't
match the actual type of the value (e.g. using sqlite_column_text on an
integer value to retrieve the textual representation of the integer).
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users