Hi,<br><br>sorry to reply so late.<br><br>I'm using DBF als back-end database. I will try it with sqlite.<br><br>Thanks<br><br><br><br><div><span class="gmail_quote">2008/5/29, Glynn Clements <<a href="mailto:glynn@gclements.plus.com">glynn@gclements.plus.com</a>>:</span><blockquote class="gmail_quote" style="margin-top: 0; margin-right: 0; margin-bottom: 0; margin-left: 0; margin-left: 0.80ex; border-left-color: #cccccc; border-left-width: 1px; border-left-style: solid; padding-left: 1ex">
<br> Moritz Lennert wrote:<br><br> > >> someone knows why this statement doesn't work?<br> > >><br> > >> echo "UPDATE grenzen gr SET gr.cleft=(SELECT adm.NAME FROM myadm0 amd WHERE gr.left= adm.cat)" | db.execute<br>
> ><br> > > Which database back-end are you using? The DBF driver only understands<br> > > a fairly limited subset of SQL; in particular, it doesn't support<br> > > subselects.<br> ><br> > And just as importantly, AFAIK, it does not support the use of more than<br>
> one table in a statement, or ?<br><br><br>Right; it doesn't support joins (or aliases).<br><br> IOW, the DBF back-end is a simple flat-file database, not a relational<br> database.<br><br><br> --<br> Glynn Clements <<a href="mailto:glynn@gclements.plus.com">glynn@gclements.plus.com</a>><br>
<br>_______________________________________________<br> grass-user mailing list<br> <a href="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</a><br> <a href="http://lists.osgeo.org/mailman/listinfo/grass-user">http://lists.osgeo.org/mailman/listinfo/grass-user</a><br>
</blockquote></div><br>