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 mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users