[GRASS-windows] syntax for v.db.select run by grass.run_command

[Liu, Huili]

Thanks Markus.
I uninstalled the old version and installed GRASS 6.4.2 from your link but I got two errors:
1. ERROR: G_getenv(): Variable LOCATION_NAME not set
2. The ordinal 63 could not be located in the dynamic link libexpat.dll.

I setup Environment Variable for LOCATION_NAME on Windows but the error 1 is still showed up. I checked libexpat.dll but I could not find it anywhere. It should come from the installation of GRASS 6.4.2, right?

-Willie




-----Original Message-----
From: neteler.osgeo at gmail.com [mailto:neteler.osgeo at gmail.com] On Behalf Of Markus Neteler
Sent: Tuesday, March 13, 2012 3:51 PM
To: Liu, Huili
Cc: grass-windows at lists.osgeo.org
Subject: Re: [GRASS-windows] syntax for v.db.select run by grass.run_command

Hi Willie,

On Tue, Mar 13, 2012 at 3:32 PM, Liu, Huili <HLiu at ap.org> wrote:
> Hi Markus,
>
> I am running GRASS GIS 6.4.1 (Windows).

would you mind to upgrade to 6.4.2?
http://grass.osgeo.org/announces/announce_grass642.html

This version has a new GRASS Python ctypes interface which may be of interest since it is way more stable than previous approaches.

Markus


> Thanks,
> Willie
>
>
>
> -----Original Message-----
> From: grass-windows-bounces at lists.osgeo.org 
> [mailto:grass-windows-bounces at lists.osgeo.org] On Behalf Of Markus 
> Neteler
> Sent: Monday, March 12, 2012 7:27 PM
> To: Liu, Huili
> Cc: grass-windows at lists.osgeo.org
> Subject: Re: [GRASS-windows] syntax for v.db.select run by 
> grass.run_command
>
> On Fri, Mar 9, 2012 at 3:46 PM, Liu, Huili <HLiu at ap.org> wrote:
>> Thanks Markus. That is a great example to generate a report.
>> DBF driver doesn't support for join tables
>
> No because DBF is really only a table format.
>
>> so I have to add a color column in the table to shade polygon. But 
>> grass.run_command('v.db.addcol', map='from_shape', columns='WINNER_COLOR, VARCHAR()') requires awk. After I installed awk, it still show the same error. awk is in environment variable and ran fine by cmd. Not sure if it is a bug on Windows.
>
> It will be some path problem... Do you use GRASS 6 or 7?
> (maybe I forgot).
>
> Markus
> _______________________________________________
> grass-windows mailing list
> grass-windows at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-windows
>
>
> The information contained in this communication is intended for the 
> use of the designated recipients named above. If the reader of this 
> communication is not the intended recipient, you are hereby notified 
> that you have received this communication in error, and that any 
> review, dissemination, distribution or copying of this communication 
> is strictly prohibited. If you have received this communication in 
> error, please notify The Associated Press immediately by telephone at 
> +1-212-621-1898 and delete this email. Thank you.
> [IP_US_DISC]
>
> msk dccc60c6d2c3a6438f0cf467d9a4938
>