Hi all, I posted my question on sqlite lists, and unfortunatly, nothing has changed in future releases. As anyone been dealing with sqlite dev's. I think this issue needs some love from us.
See the Answer I receive: > -----Message d'origine----- > De : [email protected] [mailto:sqlite-users- > [email protected]] De la part de HAUBOURG > Envoyé : lundi 17 juin 2013 09:59 > À : 'General Discussion of SQLite Database' > Objet : Re: [sqlite] Computed columns in VIEWs return NULL but should be > able to be typed! Any ideas? > > 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 > > > > -----Message d'origine----- > > De : [email protected] [mailto:sqlite-users- > > [email protected]] 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 <[email protected]>: > > > 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 > > > [email protected] > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Spatialite-can-t-type-fields-of-a-view-tp5058436p5060521.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
