yhema.2705 <yhema.2705 <at> gmail.com> writes: > > hi , > > I have build gdal 1.11 with spatialite and sqlite support. I want the layer > attributes of the shape file be updated with trignometric values .Update is > functioning well for arithemetic functions for trignometric functions it is > giving error : ERROR 1: In ExecuteSQL(): sqlite3_prepare(UPDATE gemetry_test > SET ID = tan(45) ): > no such function: tan. > thanks all
Works for me with the Windows binaries (v.2.0-dev) from gisinternalt.com. C:\temp\>ogrinfo -dialect sqlite tantest.shp -sql "update tantest set num=tan(45)" C:\temp\>ogrinfo tantest.shp -al INFO: Open of `tantest.shp' using driver `ESRI Shapefile' successful. Layer name: tantest Geometry: Polygon Feature Count: 1 Extent: (3213863.000000, 6802915.000000) - (3215302.000000, 6804011.000000) Layer SRS WKT: (unknown) num: Real (33.16) OGRFeature(tantest):0 num (Real) = 1.6197751905438615 POLYGON ((3213863 6803646,3215055 6804011,3215302 6803152,3214776 6802915,3213863 6803646)) -Jukka Rahkonen- _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev