https://www.sqlite.org/c3ref/column_blob.html
int sqlite3_column_type(sqlite3_stmt*, int iCol); ? On Mon, May 7, 2018 at 4:28 PM, Bart Smissaert <bart.smissa...@gmail.com> wrote: > Yes, thanks, that might be the best way, but it can get a bit complicated > with complex SQL. > > RBS > > > > On Tue, May 8, 2018 at 12:05 AM, Simon Slavin <slav...@bigfraud.org> > wrote: > > > On 7 May 2018, at 10:49pm, Bart Smissaert <bart.smissa...@gmail.com> > > wrote: > > > > > Using B4A for a SQLite database app on an Android phone. > > > B4A doesn't have functions like sqlite3_column_decltype and > > > sqlite3_column_type > > > and this is causing some difficulty getting the column datatypes of a > > row producing statement. > > > > See page 30 of the Basic4android manual, downloadable from > > > > <https://www.b4x.com/b4a.html> > > > > The general idea is to execute a query like > > > > SELECT ID, Name, Age, Height, typeof(Name), typeof(Age), > > typeof(Height) FROM Table1 > > > > Simon. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users