[gdal-dev] ogrinfo sql UPDATE

Giuseppe Amatulli giuseppe.amatulli at gmail.com
Wed Sep 5 14:23:42 PDT 2012


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 wyoming SET area=1000  WHERE area is NULL'
ERROR 1: SQL Expression Parsing Error: syntax error

Is sql update supported or i miss something?

Thanks
Giuseppe


-- 
Giuseppe Amatulli
Web: www.spatial-ecology.net


More information about the gdal-dev mailing list