Hi Even, thanks for the reply. I was meaning to be able to use it on other file types, such as shape and TAB, as one would specify -dialect SQLITE when doing ogrinfo.
Cheers * Marco Giana* On Thu, Jun 16, 2016 at 9:59 PM, Even Rouault <[email protected]> wrote: > Le jeudi 16 juin 2016 09:04:00, Marco Giana a écrit : > > Hi, > > > > I have a layer config > > > > CONNECTION > "E:\\All\\Data\\Kingston\\VicMap\\Tab\\KINGSTON_LGA_POLYGON.tab" > > CONNECTIONTYPE OGR > > DATA "SELECT * FROM KINGSTON_LGA_POLYGON" > > > > wondering, is it possible set DIALECT SQLITE in the MapFile to be able to > > use spatialite SQL rather than OGR_SQL in the DATA tag? > > That should work. OGR_DS_ExecuteSQL() is run without any explicit dialect, > so > it is the default dialect of each OGR driver that is used, and in the case > of > SQLite/Spatialite, it will evaluated by SQLite itself. > > > > > Cheers > > > > * Marco Giana* > > -- > Spatialys - Geospatial professional services > http://www.spatialys.com >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
