[mapserver-users] CONNECTIONTYPE OGR use DIALECT SQLITE

[Even Rouault]

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