Re: [GRASS-user] populate a table with values from another one

2008-05-29 Thread Glynn Clements
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

Re: [GRASS-user] populate a table with values from another one

2008-05-29 Thread Manuel Sangiao
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

Re: [GRASS-user] populate a table with values from another one

2008-05-28 Thread Moritz Lennert
On 27/05/08 20:59, Glynn Clements wrote: Manuel Sangiao 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