[GRASS-dev] DBF driver: semicolon and select troubles

[Markus Neteler]

Hi,

when having a semicolon at the end of a statement, the DBF driver gives
an error:

echo "select start_map, end_map, start_mp, start_off, end_mp, end_off,
lid from route_lrs where lcat = 1;" | db.select
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected $undefined, expecting $end
processing ';'
in statement:
select start_map, end_map, start_mp, start_off, end_mp, end_off, lid
from route_lrs where lcat = 1;
Error in db_open_select_cursor()

This is a problem, because other drivers seem to require it (see
v.lrs.label).

Without semicolon, it works:
 echo "select start_map, end_map, start_mp, start_off, end_mp, end_off,
lid from route_lrs where lcat = 1" | db.select
start_map|end_map|start_mp|start_off|end_mp|end_off|lid
185.206836|596.743043|6|0|7|0|22

How to enable the DBF driver to also accept the semicolon here?

markus

------------------
ITC -> dall'1 marzo 2007 Fondazione Bruno Kessler
ITC -> since 1 March 2007 Fondazione Bruno Kessler
------------------