Yes, I think the only solution might be to clean up the tables So if for example there is text in a real column, update it to 0.0 etc.
RBS On Tue, May 8, 2018 at 5:46 PM, Simon Slavin <slav...@bigfraud.org> wrote: > On 8 May 2018, at 5:37pm, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > >> SQLite does not have column types. It has column affinities instead. > > > > OK, so I would like to see that declared column affinity as that will > > determine how to process the data. > > Ah. You don't care about the data, you want the column declaration. Okay. > > <https://sqlite.org/pragma.html#pragma_table_info> > > Do whatever you would do for a SELECT statement but instead of a SELECT > statement execute > > PRAGMA schema.table_info(table-name) > > The problem is that you don't want that, either. Because you may be doing > JOINs or calculations. Unfortunately SQLite does not derive affinities as > it does a calculation, it just uses whatever values it finds. Sorry. > > 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