Re: [gdal-dev] SQLite-SQL problem with some layer names

2017-04-12 Thread Rahkonen Jukka (MML)
Hi, Hi, I had a try with editing the .dox file that is used for generating http://www.gdal.org/ogr_sql_sqlite.html with changeset #37971. Could you check if the text makes sense and appears right? -Jukka-

Re: [gdal-dev] SQLite-SQL problem with some layer names

2017-04-12 Thread Even Rouault
Hi Jukka, > > I have problems in using the SQLite dialect if layer names contains numbers > or underscores. I am on Windows. This is just an issue with proper escaping of double quotes in the shell. Identifiers that start with a number (and possibly underscore I haven't checked) need to be

[gdal-dev] SQLite-SQL problem with some layer names

2017-04-12 Thread Rahkonen Jukka (MML)
Hi, I have problems in using the SQLite dialect if layer names contains numbers or underscores. I am on Windows. ogrinfo -dialect sqlite 3d.shp -sql "select * from 3d" INFO: Open of `3d.shp' using driver `ESRI Shapefile' successful. ERROR 1: In ExecuteSQL(): sqlite3_prepare(select * from