[gdal-dev] GDAL sqlite /spatialite support with trignometric functions

[Jukka Rahkonen]

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-