> int sqlite3_column_type(sqlite3_stmt*, int iCol); Android and certainly B4A doesn't have that as far as I can see.
RBS On Tue, May 8, 2018 at 3:21 AM, J Decker <d3c...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users