Hi again. I am trying to determine why I cannot get any sql queries to work against oracle and through arcsde driver.
It seems the sql sentence keeps adding single-quotes to both field and value, which is not valid. For instance, a simple numeric clause: Ogrinfo -so -ro -al -sql "SELECT * FROM 'USER.TABLE' WHERE FEATID=1234" "SDE:<connection string>" Results in errors being reported in the client: "(...) using driver `SDE' successful. Layer name: GDBMAN.SREGA_PERIMETROS_REGA Geometry: Unknown (any) ERROR 1: SE_stream_fetch: -51/Underlying DBMS error Feature Count: -1 OGR_SDE: Loading GDBMAN.SREGA_PERIMETROS_REGA layerinfo. ERROR 1: SE_stream_fetch: -51/Underlying DBMS error Layer SRS WKT: (...)" In ArcSDE logs I can see this sql query being reported: WhereClause: "('OBJECTID_1') = (21522)" Which in turn raises an error in Oracle, since single-quotes are meant for values and not for field names. For field names oracle allows double-quotes. So it should really be: ("OBJECTID_2")=(21522). Then I tried a string query. And that doesn't work either... I can't figure out how to build a sql where clause in ogr with a string field that works... So, has anyone any successful experience with ogr -sql queries in Oracle or ArcSDE? Any tips? I'm not sure where the error happens, either in sde driver or ogr sql parser... Thanks, Duarte
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev