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
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
