2009/3/28 Jarek Jasiewicz <[email protected]>: > Hi > When I try to import TauDEM shape file I recive the eror: > > create table a (cat integer, LINKNO integer, DSLINKNO integer, USLINKNO1 > integer, USLINKNO2 integer, DSNODEID double precision, Order integer, Length > double precision, Magnitude integer, DS_Cont_Ar double precision, Drop > double precision, Slope double precision, Straight_L double precision, > US_Cont_Ar double precision, WSNO integer, DOUT_END double precision, > DOUT_START double precision, DOUT_MID double precision) > Error in db_execute_immediate() > > What wrong is in the table definition???
(did you copy the entire error? If yes, you seem to use an older GRASS version) In GRASS 6.4, I get: echo "create table a (cat integer, LINKNO integer, DSLINKNO integer, USLINKNO1 integer, USLINKNO2 integer, DSNODEID double precision, Order integer, Length double precision, Magnitude integer, DS_Cont_Ar double precision,Drop double precision, Slope double precision, Straight_L double precision, US_Cont_Ar double precision, WSNO integer, DOUT_END double precision, DOUT_START double precision, DOUT_MID double precision)" | db.execute DBMI-DBF driver error: SQL parser error: syntax error, unexpected ORDER, expecting NAME processing 'Order' in statement: create table a (cat integer, LINKNO integer, DSLINKNO integer, USLINKNO1 integer, USLINKNO2 integer, DSNODEID double precision, Order integer, Length double precision, Magnitude integer, DS_Cont_Ar double precision, Drop double precision, Slope double precision, Straight_Ldouble precision, US_Cont_Ar double precision, WSNO integer, DOUT_END double precision, DOUT_START double precision, DOUT_MID double precision) Error in db_execute_immediate() ERROR: Error while executing: 'create table a (cat integer, LINKNO integer, ... One column is called "Order" which is a reserved SQL word. Please use a different column name. If this is v.in.ogr, there is the cnames option to rename on the fly during import. Markus _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
