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

Reply via email to