[GRASS5] [bug #4142] (grass) sql statemts in d.m

[Kirk R. Wythers]

Hi Maciek,

Sorry for taking so long in response.
On Mar 6, 2006, at 3:34 PM, Maciek Sieczka via RT wrote:

> Kirk wrote:
>
>> I may have found a bug in d.m. However, I may not be issuing the sql
>> statement properly in d.m. For example If issue the following
>> command on the command line:
>>
>> d.vect test fcolor=none where="type='JAPI'"
>>
>> the expected polygons are displayed.
>>
>> However, in d.m, if I type in the SQL where statement field:
>>
>> "type = 'JAPI'"
>>
>> which I believe is the same command minus the (where=) that worked
>> on the command line, no vectors are displayed. Console output is as
>> follows:
>>
>> d.vect map=test color=0:0:0 lcolor=0:0:0 fcolor=none display=shape
>> type=point,line,boundary,centroid,area icon=basic/x size=5 layer=1
>> lsize=8 xref=left yref=center llayer=1 {where="type = 'JAPI'"}
>>
>> Am I misusing the sql field in d.m, or should this be working?
>
> If you put type = 'JAPI' (no " ") in d.m it should work, does it?

Yes, single quotes work. However, without double quotes is it  
possible to do a complex query?

For example: type = 'JAPI' and 'SP' does not work, and adding the  
double quotes like this: "type = 'JAPI' and 'SP'" does not work either.

>
> Please confirm.
>
> Maciek
>
>
> -------------------------------------------- Managed by Request  
> Tracker
>
> _______________________________________________
> grass5 mailing list
> grass5 at grass.itc.it
> http://grass.itc.it/mailman/listinfo/grass5