Thanks Stephan for your feedback. Bad news for me. I see two solutions: - hire a dev for this. I'm not following enough sqlite lists to estimate if this is feasible. Any opinion? - hire a QGIS dev to hack a autodetection of type using content of fields. Ugly, probably slow and prone to errors.. But feasable since I have some devs.
Cheers, Régis Cordialement, Régis Haubourg ------------------------------------------------------------------------------------ Régis Haubourg Administrateur de données Géographiques Département des Systèmes d'Information (DCSI) Agence de l'eau Adour Garonne 90 rue du Férétra, 31078 Toulouse Cedex4 Tél: 05 61 36 82 58 Mail: regis.haubo...@eau-adour-garonne.fr http://www.eau-adour-garonne.fr Accédez aux données sur l'eau : http://adour-garonne.eaufrance.fr/ > -----Message d'origine----- > De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] De la part de Stefan Keller > Envoyé : samedi 15 juin 2013 23:09 > À : General Discussion of SQLite Database > Objet : Re: [sqlite] Computed columns in VIEWs return NULL but should be > able to be typed! Any ideas? > > Hi Régis > > I'd wish to give you a solution but I'm sorry to have new news about that > issue. > > I'd be happy if there are any SQlite devs around to give you a solution in > order to make this database more usable (an more SQL compatible). > > Yours, Stefan > > > 2013/6/11 regish <regis.haubo...@eau-adour-garonne.fr>: > > Hi all, > > I'm starting to use SQLITE in GIS use cases. I'm facing this view > > typing column issue, which prevent my favourite client from > > interpreting correctly numeric data types. I'm using QGIS, so I won't > > be able to map numeric values (they fall back as text values). > > Is there anything new since 2010? If not, should I suggest Qgis Devs > > to hack the field type detection for views? > > Régis > > > > > > > > -- > > View this message in context: > > http://sqlite.1065341.n5.nabble.com/Computed-columns-in-VIEWs-return- > N > > ULL-but-should-be-able-to-be-typed-Any-ideas-tp56769p69350.html > > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users