On mercredi 6 février 2019 16:02:44 CET Rahkonen Jukka (MML) wrote: > Hi, > > I was awaiting that the following ogrinfo command woud add a new column but > it didn't > > ogrinfo -dialect sqlite -sql "alter table fidtest add column foo" > fidtest.shp INFO: Open of `fidtest.shp' > using driver `ESRI Shapefile' successful. > ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(alter table fidtest add foo): > no such table: fidtest > > I did succeed with OGR SQL dialect but I wonder why SQLite dialect fails.
The SQLite dialect uses the SQLite virtual table mechanism internally. That mechanism cannot modify table structure. Even -- Spatialys - Geospatial professional services http://www.spatialys.com _______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
