<br><br><div><span class="gmail_quote">2006/11/9, Moritz Lennert <<a href="mailto:mlennert@club.worldonline.be">mlennert@club.worldonline.be</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Raffaele Morelli wrote:<br> > The solution would be to work with views.<br>> Grass sees views, connects to views and this is wonderful, but... more<br>> it would be if it could handle them correctly. I tried to link to views
<br>> but quering on the attributes doesn't work correctly.<br><br>I use views successfully quite often with the postgres driver. Could you<br>be more specific about what does not work for you ?<br><br>Moritz</blockquote>
<div><br>With grass6.0 on a debian testing I connect succesfully to views.<br>The problem arise when trying to query the layer connected to the view, it doesn't display (e.g. label) fields stored in the view or retrieve any information from there.
<br><br>It seems just like "Layer for labels" and "Layer for query" text box in the Gis Manager doesn't work properly with views, sometimes they simply ignore my SQL statements or retrieve incorrect values.
<br><br>I tried to not use MySQL specific field type, switching to INT type all my SMALLINTs, TINYNTs, but still with no success.<br><br>Raffaele<br></div></div>