Hi Roualt,
thx for patch,
I'm go to test it.
Just a question to understand how use it.
the sintax 'TABLE(GEOMETRY)' should return also the attributes from table
or only the geometry without attribute ?
regards,
--
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
Hi EDven,
I try to use the your patch with gdal and mapserer.
Now I'm able to choose the right geometry from a multi-geometry table.
also I see that using this sintax
CONNECTIONTYPE OGR
CONNECTION '/path-to-splite/database.sqlite'
DATA "select pk_uid,field1,field2,field3,geometry from
Hi,
I can't test myself right now because I cannot access gisinternals.com for
getting a fresh Windows build. However, I for using geom2 of a multigeom table
would try with
DATA 'SELECT geom2,attr1,attr2 FROM table'
You can also create a spatial view which selects geom2 on the Spatialite s
thx Jukka for response.
I'll try it just now.
>I am remembering that QGis cannot make layers from Spatialite with SQL
queries.
(sorry for OT)
there is a plugin for this it is named RT_Sql_Layer
(RT is for "Regiony Tuscany".)
It allow to define a layer as sqlquery directly on the DB for Postgres