Siva, OGR SQL dialect doesn't support updates. Use sqlite dialect. You also need to update GDAL to version 1.10.
http://www.gdal.org/ogr_sql_sqlite.html On 14 Aug 2014 20:17, "SIVA RAMA KRISHNA" <s.r.kriis...@gmail.com> wrote: > Hello, > > I am trying to update shape file with attribute values .I am performing > following > > functionality. > > QFileInfo table1(_mActiveLayer); //_mActive Layer is name of file opened > QString tablename1; > tablename1=table1.baseName(); > reader = OGRSFDriverRegistrar::Open(_mActiveLayer.toLatin1().data(), TRUE > ); > if(reader==NULL) > { > exit(0); > } > > > poLayer = reader->GetLayer(0); > querrysatatement="UPDATE " +tablename1+" set SAL= 500 where EMPCODE = 1" > ;//table Name is name of the table releated to _mActiveLayer > QByteArray bnewconn = querrysatatement.toLatin1(); > conninfonew = new char[bnewconn.length()+1]; > strcpy(conninfonew,querrysatatement.toLatin1().data()); > poLayer=reader->ExecuteSQL (conninfonew,NULL,dialect.toLatin1().data()); > > OutPut > syntax error in sql statement > > Environment: > > Unbuntu 12.04 > > Gdal version -- 1.9.2 > geos version -- 3.3.3 > > Thanks in advance to all > > > > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/gdal-dev >
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
