Hello, may be a stupid question but I am trying to create a OGR Virtual
Format file with a SQLite database foo.db3, a table named test and columns
x, y
<OGRVRTDataSource>
<OGRVRTLayer name="foo">
<SrcDataSource
relativeToVRT="1">SQLITE:database=foo.db3</SrcDataSource>
<SrcSQL>select * from test </SrcSQL>
<GeometryType>wkbPoint</GeometryType>
<LayerSRS>EPSG:31370</LayerSRS>
<GeometryField encoding="PointFromColumns" x="x" y="y"/>
</OGRVRTLayer>
</OGRVRTDataSource>
and it does not work.
With Oracle, this works
<OGRVRTDataSource>
<OGRVRTLayer name="test">
<SrcDataSource>OCI:user/password@server/schema</SrcDataSource>
<SrcSQL>select * from test</SrcSQL>
<GeometryType>wkbPoint</GeometryType>
<LayerSRS>EPSG:31370</LayerSRS>
<GeometryField encoding="PointFromColumns" x="x" y="y"/>
</OGRVRTLayer>
</OGRVRTDataSource>)
What is the correct syntax for SQLite ?
--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/OGR-Virtual-Format-for-SQLite-tp4567549p4567549.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
