Hi, sorry to reply so late.
I'm using DBF als back-end database. I will try it with sqlite. Thanks 2008/5/29, Glynn Clements <[EMAIL PROTECTED]>: > > > Moritz Lennert wrote: > > > >> someone knows why this statement doesn't work? > > >> > > >> echo "UPDATE grenzen gr SET gr.cleft=(SELECT adm.NAME FROM myadm0 amd > WHERE gr.left= adm.cat)" | db.execute > > > > > > Which database back-end are you using? The DBF driver only understands > > > a fairly limited subset of SQL; in particular, it doesn't support > > > subselects. > > > > And just as importantly, AFAIK, it does not support the use of more than > > one table in a statement, or ? > > > Right; it doesn't support joins (or aliases). > > IOW, the DBF back-end is a simple flat-file database, not a relational > database. > > > -- > Glynn Clements <[EMAIL PROTECTED]> > > _______________________________________________ > grass-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/grass-user >
_______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
