Glynn Clements wrote: > > > Markus Neteler wrote: > >> 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? > > Untested: > > --- lib/db/sqlp/yac.y 4 Mar 2007 08:34:44 -0000 1.27 > +++ lib/db/sqlp/yac.y 1 Jul 2007 06:39:47 -0000 > @@ -102,6 +102,7 @@ > | y_select > | y_update > | y_delete > + | y_sql ';' > ; > > y_alter: > > -- > Glynn Clements <[EMAIL PROTECTED]> >
Excellent, works. I have added it to 6.2.2-CVS, too. Unrelated: I get these warnings on Mandriva: bison -y -d -v yac.y yac.y:74.15-19: Warnung: symbol TABLE redeclared yac.y:75.8-11: Warnung: symbol DROP redeclared yac.y:75.13-17: Warnung: symbol TABLE redeclared bison --version bison (GNU Bison) 2.3 It this harmful? Markus -- View this message in context: http://www.nabble.com/DBF-driver%3A-semicolon-and-select-troubles-tf3994416.html#a11380125 Sent from the Grass - Dev mailing list archive at Nabble.com. _______________________________________________ grass-dev mailing list [email protected] http://grass.itc.it/mailman/listinfo/grass-dev
