OGR ODBC spatial query has invalid resultset

[Fabio D'Ovidio]

Frank Thank you very much for help !

I need a reference about documentation to find the option that you sad me to consider Views 
as Tables.

I have found the same problem here (but for MySQL DBMS) :

http://www.nabble.com/-UMN_MAPSERVER-USERS--OGR-with-SELECT-%2B-INNER-
JOIN--using--MS-SQL-views---p1259454.html

But there is no described  solution .


Could you say me a link about reference ?


On 26 Sep 2006 at 13:59, Frank Warmerdam wrote:

> Fabio D'Ovidio wrote:
> > Thank u ! I 'll try with this !
> > 
> > I have another problem. My table is a VIEW and It seems that OGR SQL doesn't connect to 
> > VIEWS but only connects to Tables
> > 
> > Is it true ?
> 
> Fabio,
> 
> I believe that views will not by default be treated as layers.  But the
> ODBC connection strings for OGR include an option for a comma delimited
> list of "tables" at the end and I think this can include a named view
> which will then be treated as a layer within OGR.
> 
> I apologize for this all being a bit hacky, and my memory weak.  It seems
> like the ODBC driver could be a full time occupation it gets used in so
> many ways by different people.  But I don't use it myself very often so it
> hard for me to keep track of all the details.
> 
> Best regards,
> -- 
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | President OSGeo, http://osgeo.org


********************************************************************************************


 Ing. Fabio D'Ovidio
 WebGIS Staff
 Planetek Italia Srl
 via Massaua, 12 - 70123 Bari - Italy
 web : http ://www.planetek.it
 e-mail : dovidio at planetek.it

********************************************************************************************