On Sat, 8 Nov 2008, Simon Davies wrote: > > Hi Rob, > > I haven't tried this, but sqlite3_column_type(sqlite3_stmt*, int iCol) > should do what you want: > http://www.sqlite.org/c3ref/column_blob.html > > Rgds, > Simon
Thanks, Simon. I found this out about two minutes after I'd posted the query. At first, I figured that to be an awkward approach, as I felt that the column_isNULL function should follow the 'get data' functions (type vs value), but given SQLite's affinity model, and upon reflection, I suppose that it is the correct approach, even though slightly non-intuitive. The other bit of trickery involved is that in order for the value types to be correct (meaningful), you have to take a "step" as it were ... with sqlite3_step 8-). In any event, I'm all sorted out, and I appreciate your very quick and accurate response. Cheers, Rob Sciuk PS: I've said it before, and at risk of repetition, thanks and kudos to DRH for what is clearly one of the most remarkable examples of FOSS *EVER*. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
