Even, thank you for your quick reply.
I downloaded the GDAL source package from scratch so the compilation should have been clean enough.
Related to CPL_DEBUG, that's a good hint! I'll try executing my code with that set and see if I find out something.
Thank you! Pierluigi Il 10/02/2015 13:42, Even Rouault ha scritto:
Le mardi 10 février 2015 12:47:46, Pierluigi Guasqui a écrit :Hi All! I am using the GDAL/OGR functions to query a shapefile. This is a sample code I have been successfully running so far: OGRDataSource *poDS = OGRSFDriverRegistrar::Open( "some/path/to/myshapefile.shp" ); OGRLayer *poLayer = poDS->ExecuteSQL( "select * from myshapefile", NULL, NULL ); // ... // fetching result features from "poLayer" // ... poDS->ReleaseResultSet( poLayer ); OGRDataSource::DestroyDataSource(poDS); As you can see, I am currently using the OGR SQL dialect, as I am passing NULL as the third parameter of the OGRDataSource::ExecuteSQL function. Now I am trying to extend the SQL syntax to be able to use the OGR SQLite dialect. I have successfully recompiled GDAL 1.11.1 with SQLite support (version 3.8.5) but when I try to execute the same sample code (passing "SQLITE" as the 3rd argument of the OGRDataSource::ExecuteSQL function) I am getting the following error: In ExecuteSQL(): sqlite3_prepare(select * from myshapefile): no such table: myshapefile What is the table name that contains the shapefile features that I can use in my SQL queries?Pierluigi, That should work... If you tried to configure GDAL several times, perhaps you should do a make clean. Could you try defining CPL_DEBUG=ON as environment variable and rerun your code. You should normally see a statement like the following one to create the SQLite virtual table that matches the shapefile layer : OGR2SQLITE: sqlite3_declare_vtab(CREATE TABLE "poly"("AREA" FLOAT,"EAS_ID" FLOAT,"PRFEDEA" VARCHAR(16),OGR_STYLE VARCHAR HIDDEN,"GEOMETRY" BLOB_POLYGON_2D_50000)) Even
-- Pierluigi Guasqui Software Engineer Applied Coherent Technology Corporation (ACT) www.actgate.com _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
