Re: [gdal-dev] ogrinfo sql UPDATE

2012-09-05 Thread Even Rouault
> ogrinfo wyoming.shp -sql 'UPDATE wyoming SET area=1000 WHERE area is > NULL' ERROR 1: SQL Expression Parsing Error: syntax error > > Is sql update supported or i miss something? UPDATE is not supported indeed. The subset of SQL understood by OGR is documented at : http://gdal.org/o

[gdal-dev] ogrinfo sql UPDATE

2012-09-05 Thread Giuseppe Amatulli
Hi I would like to insert a column in a shape file and insert a specific value on it. I succeed in insert the column by ogrinfo and sql by ogrinfo wyoming.shp -sql 'ALTER TABLE wyoming ADD COLUMN area real' but than i did not succeed in inserting the value. ogrinfo wyoming.shp -sql 'UPDATE w