[Qgis-user] Spatialite - can't type fields of a view

[Régis Haubourg]

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 : sqlite-users-bounces at sqlite.org [mailto:sqlite-users-
> bounces at sqlite.org] 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 : sqlite-users-bounces at sqlite.org [mailto:sqlite-users-
> > bounces at 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.haubourg at 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 at sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users at sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at sqlite.org
> 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.