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

[Moritz Lennert]

Kirk R. Wythers wrote:
> 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.

This should be type='JAPI' and type='SP'.

As far as I know, type='JAPI' and 'SP' is not standard SQL.

Moritz