[gdal-dev] querry in updating attribute values using ogrdatasource

2014-08-14 Thread SIVA RAMA KRISHNA 
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

Re: [gdal-dev] querry in updating attribute values using ogrdatasource

2014-08-14 Thread Chaitanya kumar CH 
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