Just tested that (TypeOf) on the Android phone and it doesn't do what I wanted. I tested on a column declared Real but with text values in it as well. It will give both real and text and what I wanted was to produce only real as that is what the column is declared as.
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
