Il 04/12/2015 17:20, Even Rouault ha scritto:
> Ah indeed when trying directly with SQLite. My initial test was through -
> dialect SQLite which uses a SQLite virtual table mechanism, and that might be
> in its implementation in OGR that it is rejected.
Thanks a lot to all for the clarifications.
Le vendredi 04 décembre 2015 17:04:12, Jürgen E. Fischer a écrit :
> Hi Even,
>
> On Fri, 04. Dec 2015 at 14:29:47 +0100, Even Rouault wrote:
> > Le vendredi 04 décembre 2015 14:08:40, Paolo Cavallini a écrit :
> > > Hi all,
> > > apparently the OGR SQL dialect is different from others:
> > > http
Hi Even,
On Fri, 04. Dec 2015 at 14:29:47 +0100, Even Rouault wrote:
> Le vendredi 04 décembre 2015 14:08:40, Paolo Cavallini a écrit :
> > Hi all,
> > apparently the OGR SQL dialect is different from others:
> > https://hub.qgis.org/issues/7380
> > Any hope to bring them to common ground?
> I be
On Fri, 4 Dec 2015 14:29:47 +0100, Even Rouault wrote:
So it looks very much like "x = NULL" is not "normal" SQL at all.
just a may be useful comment about this topic
accordingly to SQL standard syntax rules NULL should never be
confused with any other ordinary value; it's instead a special
m
Le vendredi 04 décembre 2015 14:08:40, Paolo Cavallini a écrit :
> Hi all,
> apparently the OGR SQL dialect is different from others:
> https://hub.qgis.org/issues/7380
> Any hope to bring them to common ground?
Hi Paolo,
I believe x = NULL is an extension of the SQL standard that may
be supporte
Hi all,
apparently the OGR SQL dialect is different from others:
https://hub.qgis.org/issues/7380
Any hope to bring them to common ground?
Thanks.
--
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-
Tried to copy data from a shapefile into an MSSQL layer with ogr2ogr using
the following command:
ogr2ogr -f MSSQLSpatial MSSQL:server=.;database=SpatialTest -overwrite
mydata.shp
this works fine with OGR version 1.11.x but using the newest version 2.0.1
nothing gets inserted and I get the follo
