[GRASS-dev] [GRASS GIS] #2195: "Query raster/vectors maps" tool fails while saving modified attribute

[GRASS GIS]

#2195: "Query raster/vectors maps" tool fails while saving modified attribute
-------------------------+--------------------------------------------------
 Reporter:  artegion     |       Owner:  grass-dev@…              
     Type:  defect       |      Status:  new                      
 Priority:  normal       |   Milestone:  6.4.4                    
Component:  wxGUI        |     Version:  6.4.3                    
 Keywords:               |    Platform:  All                      
      Cpu:  Unspecified  |  
-------------------------+--------------------------------------------------
Description changed by neteler:

Old description:

> If the key column is not called "cat" when saving modified attribute a
> wrong SQL command is issued
>
> UPDATE tablename SET .... WHERE cat=1;
>
> instead
> UPDATE tablename SET .... WHERE KEYNAME=1;
>
> [[Image(D:\ODBCtest\bug\Capture-2.jpg)]]

New description:

 If the key column is not called "cat" when saving modified attribute a
 wrong SQL command is issued

 UPDATE tablename SET .... WHERE cat=1;

 instead
 UPDATE tablename SET .... WHERE KEYNAME=1;

 [[Image(Capture-2.jpg)]]

--

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/2195#comment:1>
GRASS GIS <http://grass.osgeo.org>