[GRASS-user] Re: grass-user Digest, Vol 60, Issue 13

[Sharon M]

No, error message is now...

DBMI-DBF driver error:
Column 'V' not found
Incompatible types in WHERE condition.
Error in selecting rows
Error in db_execute_immediate()
ERROR: Error while executing: 'UPDATE myfields SET polynum=42 WHERE label ~ V
'

On Wed, Apr 6, 2011 at 4:36 PM, Hamish <hamish_b at yahoo.com> wrote:
> Richard wrote:
>> The dbf driver doesn't handle "like".
> ...
>> If you need more advanced query parameters such as "like",
>> use a different database driver - pg or mysql.
>
> would "~" work?
>
>  v.db.update myfields col=polynum val=42 where="label ~ 'V'"
>
> ?
>
> Hamish
>
>