[GRASS-dev] Re: [GRASS GIS] #1055: db.select can´t found columns generated by v.rast.stats with dbf driver

[GRASS GIS]

#1055: db.select can´t found columns generated by v.rast.stats with dbf driver
---------------------------+------------------------------------------------
  Reporter:  jeleniste     |       Owner:  grass-dev at lists.osgeo.org
      Type:  defect        |      Status:  new                      
  Priority:  normal        |   Milestone:  6.4.0                    
 Component:  Database      |     Version:  6.4.0 RCs                
Resolution:                |    Keywords:  dbf, db.select           
  Platform:  MSWindows XP  |         Cpu:  Unspecified              
---------------------------+------------------------------------------------
Comment (by jeleniste):

 of coururse, but
 {{{
 db.select sql="select cat,elev_n,elev_min from geo where elev_n not NULL"
 }}}
 don´t work on my distribution

 {{{
 GRASS 6.4> db.select sql="select cat, slope_n from vvp_plochy where elev_n
 not
  NULL"
 DBMI-DBF driver error:
 Column 'slope_n' not found
 Error in db_open_select_cursor()

 GRASS 6.4>
 GRASS 6.4> db.columns vvp_plochy
 cat
 CISLO_VVP
 ID
 NAZEV
 slope__n
 slope__min
 slope__max
 slope__ran
 slope__mea
 slope__std
 slope__var
 slope__cf_
 slope__sum
 GRASS 6.4>
 slope__var
 slope__cf_
 slope__sum
 }}}

 Oh. I'm so sorry, my columns have two __ in prefix.
 My fault

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