#1208: v.to.db option=start/end fails to populate database
----------------------+-----------------------------------------------------
Reporter: voncasec | Owner: grass-dev@…
Type: defect | Status: new
Priority: normal | Milestone: 6.4.1
Component: Vector | Version: svn-releasebranch64
Keywords: v.to.db | Platform: Linux
Cpu: x86-64 |
----------------------+-----------------------------------------------------
I am unable to upload the start or end coordinates of a line segment to a
database using the v.to.db command.
v.to.db map=IPLines_NorthBlock@IdealizedGrid option=start qcolumn=Start
I have tested using the North Carolina database as follows:
v.db.addcol map=busroute11@PERMANENT columns=test double
v.to.db map=busroute11@PERMANENT option=end columns=test
(Same error is reported for option=start)
v.to.db -p does successfully print all of the coordinates
Reading features...
Updating database...
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected '(', expecting
NAME processing '('
in statement:
update busroute11 set test = 637239.56871539, (null) =
226030.942582791 where cat = 1
Error in db_execute_immediate()
1 categories read from vector map (layer 1)
1 records selected from table (layer 1)
1 categories read from vector map exist in selection from table
0 records updated/inserted (layer 1)
1 update/insert errors (layer 1)
--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1208>
GRASS GIS <http://grass.osgeo.org>