[GRASS5] v.in.db segfault and sql problems
Radim Blazek
blazek at itc.it
Thu Nov 18 03:43:39 EST 2004
'DATE' is SQL reserved word, try to rename that column.
Radim
Joel Peter William Pitt wrote:
> I tried sending this a couple of days ago but it didn't show up (perhaps
> because I attached a zip file with the log, so this time it is pasted at
> the end)...
> ----
>
> Hi all,
>
> I'm trying to import a large table of points using v.in.db:
>
> v.in.db driver=dbf database='$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/'
> table=test x='GPSEast' y='GPSNorth' key=ID output=from_mdb
>
> This results in a segfault, after the SQL parser reports an error
> in one of the commands it recieves. I've attached the output
> with DEBUG set to lvl 3.
>
> The table originally comes from an Access database which I have
> converted to a dbf file.
>
> Since it is trying to copy a table with > 200 columns I was wondering
> if I'm going over some limit inherent in the dbf system or maybe
> passing the maximum length for SQL commands ? (the command is
> ~3000 chars).
>
> I can split the table up if necessary, but I thought I'd check that this
> isn't a bug (using CVS version checked out from this morning).
>
> ---
> Update: I also get errors with the simplest of SQL commands:
> e.g.
> > echo "select * from test" | db.execute
> gives me:
> DBMI: Protocol error
>
> Now I know the docs say:
> An error message such as "dbmi: Protocol error" either indicates an
> invalid column name or an unsupported column type (then the GRASS SQL
> parser needs to be extended).
>
> but these are the type of commands I've heard other people doing without
> any
> problems.
>
> Cheers,
> Joel
>
> D2/3: Vect_open_new(): name = from_mdb
> D1/3: Vect_set_thresh(): thresh = 0.000000
> WARNING: The vector 'from_mdb' already exists and will be overwritten.
> D3/3: Delete vector 'from_mdb'
> D1/3: Vect_open_old(): name = from_mdb mapset= PERMANENT update = 0
> D1/3: Vect_set_thresh(): thresh = 0.000000
> D1/3: dig_spidx_init()
> D2/3: dig_cidx_init()
> D1/3: open format file: 'PERMANENT/vector/from_mdb/frmt'
> D1/3: Vector format: 0 (native)
> D1/3: Vect__read_head(): vector = from_mdb at PERMANENT
> D1/3: Vect_set_thresh(): thresh = 0.000000
> D1/3: Level request = 1
> D1/3: Vect_open_old(): vector opened on level 1
> D1/3: Vect_read_dblinks(): map = from_mdb, mapset = PERMANENT
> D1/3: dbln file:
> /home/pittj2/gis_databases/nzmg/PERMANENT/vector/from_mdb/dbln
> D1/3: Cannot open vector database definition file
> D1/3: Vect_close(): name = from_mdb, mapset = PERMANENT, format = 0,
> level = 1
> D1/3: close history file
> D3/3: opendir '/home/pittj2/gis_databases/nzmg/PERMANENT/vector/from_mdb'
> D3/3: delete file
> '/home/pittj2/gis_databases/nzmg/PERMANENT/vector/from_mdb/coor'
> D3/3: delete file
> '/home/pittj2/gis_databases/nzmg/PERMANENT/vector/from_mdb/head'
> D3/3: delete file
> '/home/pittj2/gis_databases/nzmg/PERMANENT/vector/from_mdb/hist'
> D3/3: delete directory
> '/home/pittj2/gis_databases/nzmg/PERMANENT/vector/from_mdb'
> D1/3: V1_open_new_nat(): name = from_mdb
> D1/3: Vect_get_thresh(): thresh = 0.000000
> D1/3: dig__write_head()
> D1/3: write coor size (0) to head
> D2/3: coor body offset 14
> D1/3: dig_spidx_init()
> D2/3: dig_cidx_init()
> D3/3: Vect_hist_command()
> D3/3: G_recreate_command()
> D1/3: Vect_default_field_info(): map = from_mdb field = 1
> D2/3: drv = dbf db = $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
> D3/3: db_start_driver_open_database():
> drvname = dbf, dbname = $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
> D2/3: add_table(): table = info name = info.dbf
> D2/3: add_table(): table = mos_txarea name = mos_txarea.dbf
> D2/3: add_table(): table = test name = test.dbf
> D2/3: add_table(): table = nzcoast_high name = nzcoast_high.dbf
> D2/3: add_table(): table = territories name = territories.dbf
> D2/3: SQL: select ID, GPSEast, GPSNorth from test
> D3/3: SQL statement parsed successfully
> D2/3: find_table(): table = test
> D2/3: ? info
> D2/3: ? mos_txarea
> D2/3: ? test
> D2/3: load_table_head(): tab = 2,
> /home/pittj2/gis_databases/nzmg/PERMANENT/dbf//test.dbf
> D2/3: ncols = 111
> D2/3: DBFFieldType 1
> D3/3: add_column(): tab = 2, type = 2, name = ID, width = 5, decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = ORGANISATI, width = 22,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = COLLECTOR, width = 32,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = SAMPLE_NUM, width = 29,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = DATE, width = 10, decimals
> = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = LOCATION, width = 50,
> decimals = 0
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = GPSEAST, width = 10,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = GPSNORTH, width = 11,
> decimals = 2
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = SITE_REFER, width = 50,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = PORT_SAMPL, width = 7,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = TRAP_, width = 6, decimals
> = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = REASON_FOR, width = 14,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = SAMPLE_TYP, width = 7,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = HABITAT_CA, width = 46,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = SALINITY, width = 6,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = TEMPERATUR, width = 7,
> decimals = 0
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = TOTAL_DIPS, width = 9,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = POS_DIPS, width = 9,
> decimals = 2
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = TRAP_TYPE, width = 14,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = ATTRACTANT, width = 25,
> decimals = 0
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTOR, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTO2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTO3, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTO4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTO5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTO6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPOD, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPO2, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPO3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPO4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPO5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPO6, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSCR, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSC2, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSC3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSC4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSC5, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSC6, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIGI, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIG2, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIG3, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIG4, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIG5, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIG6, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQUE, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQU2, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQU3, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQU4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQU5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQU6, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRAL, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRA2, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRA3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRA4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRA5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRA6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS_, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS2, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS6, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALBI, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALB2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALB3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALB4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALB5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALB6, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYROP, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYRO2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYRO3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYRO4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYRO5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYRO6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_T, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_3, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_N, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_7, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_8, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_9, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA10, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA11, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORUA, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORU2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORU3, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORU4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORU5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORU6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELIA, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELI2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELI3, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELI4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELI5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELI6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLETT, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLET2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLET3, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLET4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLET5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLET6, width = 6,
> decimals = 2
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTATU, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTAT2, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTAT3, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTAT4, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTAT5, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTAT6, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = EXOTIC_SPE, width = 38,
> decimals = 0
> D2/3: SELECT
> D2/3: sel(): tab = 2
> D2/3: load_table(): tab = 2
> D2/3: ncols = 111 nrows = 10058
> D2/3: load_table_head(): tab = 2,
> /home/pittj2/gis_databases/nzmg/PERMANENT/dbf//test.dbf
> D3/3: Vect_write_line(): name = from_mdb, format = 0, level = 1
> <snip several thousand lines that are the same as above>
> D3/3: Vect_write_line(): name = from_mdb, format = 0, level = 1
> D2/3: save_table 0
> D2/3: save_table 1
> D2/3: save_table 2
> D2/3: save_table 3
> D2/3: save_table 4
> D3/3: db_copy_table():
> from driver = dbf, db = $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/, table =
> test
> to driver = dbf, db = $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/, table =
> from_mdb, where = (null), select = (null)
> D2/3: add_table(): table = info name = info.dbf
> D2/3: add_table(): table = mos_txarea name = mos_txarea.dbf
> D2/3: add_table(): table = test name = test.dbf
> D2/3: add_table(): table = nzcoast_high name = nzcoast_high.dbf
> D2/3: add_table(): table = territories name = territories.dbf
> D2/3: add_table(): table = info name = info.dbf
> D2/3: add_table(): table = mos_txarea name = mos_txarea.dbf
> D2/3: add_table(): table = test name = test.dbf
> D2/3: add_table(): table = nzcoast_high name = nzcoast_high.dbf
> D2/3: add_table(): table = territories name = territories.dbf
> D2/3: Begin transaction
> D3/3: select * from test
> D3/3: SQL statement parsed successfully
> D2/3: find_table(): table = test
> D2/3: ? info
> D2/3: ? mos_txarea
> D2/3: ? test
> D2/3: load_table_head(): tab = 2,
> /home/pittj2/gis_databases/nzmg/PERMANENT/dbf//test.dbf
> D2/3: ncols = 111
> D2/3: DBFFieldType 1
> D3/3: add_column(): tab = 2, type = 2, name = ID, width = 5, decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = ORGANISATI, width = 22,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = COLLECTOR, width = 32,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = SAMPLE_NUM, width = 29,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = DATE, width = 10, decimals
> = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = LOCATION, width = 50,
> decimals = 0
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = GPSEAST, width = 10,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = GPSNORTH, width = 11,
> decimals = 2
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = SITE_REFER, width = 50,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = PORT_SAMPL, width = 7,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = TRAP_, width = 6, decimals
> = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = REASON_FOR, width = 14,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = SAMPLE_TYP, width = 7,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = HABITAT_CA, width = 46,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = SALINITY, width = 6,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = TEMPERATUR, width = 7,
> decimals = 0
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = TOTAL_DIPS, width = 9,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = POS_DIPS, width = 9,
> decimals = 2
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = TRAP_TYPE, width = 14,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = ATTRACTANT, width = 25,
> decimals = 0
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTOR, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTO2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTO3, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTO4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTO5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_CAMPTO6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPOD, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPO2, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPO3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPO4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPO5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_ANTIPO6, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSCR, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSC2, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSC3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSC4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSC5, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_NOTOSC6, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIGI, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIG2, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIG3, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIG4, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIG5, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_PERVIG6, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQUE, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQU2, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQU3, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQU4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQU5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_QUINQU6, width = 6,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRAL, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRA2, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRA3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRA4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRA5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_AUSTRA6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS_, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS2, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OP_FUSCUS6, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALBI, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALB2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALB3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALB4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALB5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = OC_SUBALB6, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYROP, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYRO2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYRO3, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYRO4, width = 5,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYRO5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = MA_ARGYRO6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_T, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_3, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_N, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_7, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_8, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA_9, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA10, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CULISETA11, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORUA, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORU2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORU3, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORU4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORU5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ROTORU6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELIA, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELI2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELI3, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELI4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELI5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = CX_ASTELI6, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLETT, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLET2, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLET3, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLET4, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLET5, width = 4,
> decimals = 2
> D2/3: DBFFieldType 2
> D3/3: add_column(): tab = 2, type = 3, name = COQUILLET6, width = 6,
> decimals = 2
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTATU, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTAT2, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTAT3, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTAT4, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTAT5, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = OCLEROTAT6, width = 1,
> decimals = 0
> D2/3: DBFFieldType 0
> D3/3: add_column(): tab = 2, type = 1, name = EXOTIC_SPE, width = 38,
> decimals = 0
> D2/3: SELECT
> D2/3: sel(): tab = 2
> D2/3: load_table(): tab = 2
> D2/3: ncols = 111 nrows = 10058
> D2/3: load_table_head(): tab = 2,
> /home/pittj2/gis_databases/nzmg/PERMANENT/dbf//test.dbf
> D3/3: Select cursor opened
> D3/3: ncols = 111
> D3/3: ID (INTEGER)
> D3/3: ORGANISATI (CHARACTER)
> D3/3: COLLECTOR (CHARACTER)
> D3/3: SAMPLE_NUM (CHARACTER)
> D3/3: DATE (CHARACTER)
> D3/3: LOCATION (CHARACTER)
> D3/3: GPSEAST (DOUBLE PRECISION)
> D3/3: GPSNORTH (DOUBLE PRECISION)
> D3/3: SITE_REFER (CHARACTER)
> D3/3: PORT_SAMPL (CHARACTER)
> D3/3: TRAP_ (CHARACTER)
> D3/3: REASON_FOR (CHARACTER)
> D3/3: SAMPLE_TYP (CHARACTER)
> D3/3: HABITAT_CA (CHARACTER)
> D3/3: SALINITY (CHARACTER)
> D3/3: TEMPERATUR (CHARACTER)
> D3/3: TOTAL_DIPS (DOUBLE PRECISION)
> D3/3: POS_DIPS (DOUBLE PRECISION)
> D3/3: TRAP_TYPE (CHARACTER)
> D3/3: ATTRACTANT (CHARACTER)
> D3/3: OC_CAMPTOR (DOUBLE PRECISION)
> D3/3: OC_CAMPTO2 (DOUBLE PRECISION)
> D3/3: OC_CAMPTO3 (DOUBLE PRECISION)
> D3/3: OC_CAMPTO4 (DOUBLE PRECISION)
> D3/3: OC_CAMPTO5 (DOUBLE PRECISION)
> D3/3: OC_CAMPTO6 (DOUBLE PRECISION)
> D3/3: OC_ANTIPOD (DOUBLE PRECISION)
> D3/3: OC_ANTIPO2 (DOUBLE PRECISION)
> D3/3: OC_ANTIPO3 (DOUBLE PRECISION)
> D3/3: OC_ANTIPO4 (DOUBLE PRECISION)
> D3/3: OC_ANTIPO5 (DOUBLE PRECISION)
> D3/3: OC_ANTIPO6 (DOUBLE PRECISION)
> D3/3: OC_NOTOSCR (DOUBLE PRECISION)
> D3/3: OC_NOTOSC2 (DOUBLE PRECISION)
> D3/3: OC_NOTOSC3 (DOUBLE PRECISION)
> D3/3: OC_NOTOSC4 (DOUBLE PRECISION)
> D3/3: OC_NOTOSC5 (DOUBLE PRECISION)
> D3/3: OC_NOTOSC6 (DOUBLE PRECISION)
> D3/3: CX_PERVIGI (DOUBLE PRECISION)
> D3/3: CX_PERVIG2 (DOUBLE PRECISION)
> D3/3: CX_PERVIG3 (DOUBLE PRECISION)
> D3/3: CX_PERVIG4 (DOUBLE PRECISION)
> D3/3: CX_PERVIG5 (DOUBLE PRECISION)
> D3/3: CX_PERVIG6 (DOUBLE PRECISION)
> D3/3: CX_QUINQUE (DOUBLE PRECISION)
> D3/3: CX_QUINQU2 (DOUBLE PRECISION)
> D3/3: CX_QUINQU3 (DOUBLE PRECISION)
> D3/3: CX_QUINQU4 (DOUBLE PRECISION)
> D3/3: CX_QUINQU5 (DOUBLE PRECISION)
> D3/3: CX_QUINQU6 (DOUBLE PRECISION)
> D3/3: OC_AUSTRAL (DOUBLE PRECISION)
> D3/3: OC_AUSTRA2 (DOUBLE PRECISION)
> D3/3: OC_AUSTRA3 (DOUBLE PRECISION)
> D3/3: OC_AUSTRA4 (DOUBLE PRECISION)
> D3/3: OC_AUSTRA5 (DOUBLE PRECISION)
> D3/3: OC_AUSTRA6 (DOUBLE PRECISION)
> D3/3: OP_FUSCUS_ (DOUBLE PRECISION)
> D3/3: OP_FUSCUS2 (DOUBLE PRECISION)
> D3/3: OP_FUSCUS3 (DOUBLE PRECISION)
> D3/3: OP_FUSCUS4 (DOUBLE PRECISION)
> D3/3: OP_FUSCUS5 (DOUBLE PRECISION)
> D3/3: OP_FUSCUS6 (DOUBLE PRECISION)
> D3/3: OC_SUBALBI (DOUBLE PRECISION)
> D3/3: OC_SUBALB2 (DOUBLE PRECISION)
> D3/3: OC_SUBALB3 (DOUBLE PRECISION)
> D3/3: OC_SUBALB4 (DOUBLE PRECISION)
> D3/3: OC_SUBALB5 (DOUBLE PRECISION)
> D3/3: OC_SUBALB6 (DOUBLE PRECISION)
> D3/3: MA_ARGYROP (DOUBLE PRECISION)
> D3/3: MA_ARGYRO2 (DOUBLE PRECISION)
> D3/3: MA_ARGYRO3 (DOUBLE PRECISION)
> D3/3: MA_ARGYRO4 (DOUBLE PRECISION)
> D3/3: MA_ARGYRO5 (DOUBLE PRECISION)
> D3/3: MA_ARGYRO6 (DOUBLE PRECISION)
> D3/3: CULISETA_T (DOUBLE PRECISION)
> D3/3: CULISETA_2 (DOUBLE PRECISION)
> D3/3: CULISETA_3 (DOUBLE PRECISION)
> D3/3: CULISETA_4 (DOUBLE PRECISION)
> D3/3: CULISETA_5 (DOUBLE PRECISION)
> D3/3: CULISETA_6 (DOUBLE PRECISION)
> D3/3: CULISETA_N (DOUBLE PRECISION)
> D3/3: CULISETA_7 (DOUBLE PRECISION)
> D3/3: CULISETA_8 (DOUBLE PRECISION)
> D3/3: CULISETA_9 (DOUBLE PRECISION)
> D3/3: CULISETA10 (DOUBLE PRECISION)
> D3/3: CULISETA11 (DOUBLE PRECISION)
> D3/3: CX_ROTORUA (DOUBLE PRECISION)
> D3/3: CX_ROTORU2 (DOUBLE PRECISION)
> D3/3: CX_ROTORU3 (DOUBLE PRECISION)
> D3/3: CX_ROTORU4 (DOUBLE PRECISION)
> D3/3: CX_ROTORU5 (DOUBLE PRECISION)
> D3/3: CX_ROTORU6 (DOUBLE PRECISION)
> D3/3: CX_ASTELIA (DOUBLE PRECISION)
> D3/3: CX_ASTELI2 (DOUBLE PRECISION)
> D3/3: CX_ASTELI3 (DOUBLE PRECISION)
> D3/3: CX_ASTELI4 (DOUBLE PRECISION)
> D3/3: CX_ASTELI5 (DOUBLE PRECISION)
> D3/3: CX_ASTELI6 (DOUBLE PRECISION)
> D3/3: COQUILLETT (DOUBLE PRECISION)
> D3/3: COQUILLET2 (DOUBLE PRECISION)
> D3/3: COQUILLET3 (DOUBLE PRECISION)
> D3/3: COQUILLET4 (DOUBLE PRECISION)
> D3/3: COQUILLET5 (DOUBLE PRECISION)
> D3/3: COQUILLET6 (DOUBLE PRECISION)
> D3/3: OCLEROTATU (CHARACTER)
> D3/3: OCLEROTAT2 (CHARACTER)
> D3/3: OCLEROTAT3 (CHARACTER)
> D3/3: OCLEROTAT4 (CHARACTER)
> D3/3: OCLEROTAT5 (CHARACTER)
> D3/3: OCLEROTAT6 (CHARACTER)
> D3/3: EXOTIC_SPE (CHARACTER)
> D3/3: create table from_mdb ( ID integer, ORGANISATI varchar(22),
> COLLECTOR varchar(32), SAMPLE_NUM varchar(29), DATE varchar(10),
> LOCATION varchar(50), GPSEAST double precision, GPSNORTH double
> precision, SITE_REFER varchar(50), PORT_SAMPL varchar(7), TRAP_
> varchar(6), REASON_FOR varchar(14), SAMPLE_TYP varchar(7), HABITAT_CA
> varchar(46), SALINITY varchar(6), TEMPERATUR varchar(7), TOTAL_DIPS
> double precision, POS_DIPS double precision, TRAP_TYPE varchar(14),
> ATTRACTANT varchar(25), OC_CAMPTOR double precision, OC_CAMPTO2 double
> precision, OC_CAMPTO3 double precision, OC_CAMPTO4 double precision,
> OC_CAMPTO5 double precision, OC_CAMPTO6 double precision, OC_ANTIPOD
> double precision, OC_ANTIPO2 double precision, OC_ANTIPO3 double
> precision, OC_ANTIPO4 double precision, OC_ANTIPO5 double precision,
> OC_ANTIPO6 double precision, OC_NOTOSCR double precision, OC_NOTOSC2
> double precision, OC_NOTOSC3 double precision, OC_NOTOSC4 double
> precision, OC_NOTOSC5 double precision, OC_NOTOSC6 double precision,
> CX_PERVIGI double precision, CX_PERVIG2 double precision, CX_PERVIG3
> double precision, CX_PERVIG4 double precision, CX_PERVIG5 double
> precision, CX_PERVIG6 double precision, CX_QUINQUE double precision,
> CX_QUINQU2 double precision, CX_QUINQU3 double precision, CX_QUINQU4
> double precision, CX_QUINQU5 double precision, CX_QUINQU6 double
> precision, OC_AUSTRAL double precision, OC_AUSTRA2 double precision,
> OC_AUSTRA3 double precision, OC_AUSTRA4 double precision, OC_AUSTRA5
> double precision, OC_AUSTRA6 double precision, OP_FUSCUS_ double
> precision, OP_FUSCUS2 double precision, OP_FUSCUS3 double precision,
> OP_FUSCUS4 double precision, OP_FUSCUS5 double precision, OP_FUSCUS6
> double precision, OC_SUBALBI double precision, OC_SUBALB2 double
> precision, OC_SUBALB3 double precision, OC_SUBALB4 double precision,
> OC_SUBALB5 double precision, OC_SUBALB6 double precision, MA_ARGYROP
> double precision, MA_ARGYRO2 double precision, MA_ARGYRO3 double
> precision, MA_ARGYRO4 double precision, MA_ARGYRO5 double precision,
> MA_ARGYRO6 double precision, CULISETA_T double precision, CULISETA_2
> double precision, CULISETA_3 double precision, CULISETA_4 double
> precision, CULISETA_5 double precision, CULISETA_6 double precision,
> CULISETA_N double precision, CULISETA_7 double precision, CULISETA_8
> double precision, CULISETA_9 double precision, CULISETA10 double
> precision, CULISETA11 double precision, CX_ROTORUA double precision,
> CX_ROTORU2 double precision, CX_ROTORU3 double precision, CX_ROTORU4
> double precision, CX_ROTORU5 double precision, CX_ROTORU6 double
> precision, CX_ASTELIA double precision, CX_ASTELI2 double precision,
> CX_ASTELI3 double precision, CX_ASTELI4 double precision, CX_ASTELI5
> double precision, CX_ASTELI6 double precision, COQUILLETT double
> precision, COQUILLET2 double precision, COQUILLET3 double precision,
> COQUILLET4 double precision, COQUILLET5 double precision, COQUILLET6
> double precision, OCLEROTATU varchar(1), OCLEROTAT2 varchar(1),
> OCLEROTAT3 varchar(1), OCLEROTAT4 varchar(1), OCLEROTAT5 varchar(1),
> OCLEROTAT6 varchar(1), EXOTIC_SPE varchar(38))
> DBMI-DBF driver error:
> SQL parser error in statement:
> create table from_mdb ( ID integer, ORGANISATI varchar(22), COLLECTOR
> varchar(32), SAMPLE_NUM varchar(29), DATE varchar(10), LOCATION
> varchar(50), GPSEAST double precision, GPSNORTH double precision,
> SITE_REFER varchar(50), PORT_SAMPL varchar(7), TRAP_ varchar(6),
> REASON_FOR varchar(14), SAMPLE_TYP varchar(7), HABITAT_CA varchar(46),
> SALINITY varchar(6), TEMPERATUR varchar(7), TOTAL_DIPS double precision,
> POS_DIPS double precision, TRAP_TYPE varchar(14), ATTRACTANT
> varchar(25), OC_CAMPTOR double precision, OC_CAMPTO2 double precision,
> OC_CAMPTO3 double precision, OC_CAMPTO4 double precision, OC_CAMPTO5
> double precision, OC_CAMPTO6 double precision, OC_ANTIPOD double
> precision, OC_ANTIPO2 double precision, OC_ANTIPO3 double precision,
> OC_ANTIPO4 double precision, OC_ANTIPO5 double precision, OC_ANTIPO6
> double precision, OC_NOTOSCR double precision, OC_NOTOSC2 double
> precision, OC_NOTOSC3 double precision, OC_NOTOSC4 double precision,
> OC_NOTOSC5 double precision, OC_NOTOSC6 double precision, CX_PERVIGI
> double precision, CX_PERVIG2 double precision, CX_PERVIG3 double
> precision, CX_PERVIG4 double precision, CX_PERVIG5 double precision,
> CX_PERVIG6 double precision, CX_QUINQUE double precision, CX_QUINQU2
> double precision, CX_QUINQU3 double precision, CX_QUINQU4 double
> precision, CX_QUINQU5 double precision, CX_QUINQU6 double precision,
> OC_AUSTRAL double precision, OC_AUSTRA2 double precision, OC_AUSTRA3
> double precision, OC_AUSTRA4 double precision, OC_AUSTRA5 double
> precision, OC_AUSTRA6 double precision, OP_FUSCUS_ double precision,
> OP_FUSCUS2 double precision, OP_FUSCUS3 double precision, OP_FUSCUS4
> double precision, OP_FUSCUS5 double precision, OP_FUSCUS6 double
> precision, OC_SUBALBI double precision, OC_SUBALB2 double precision,
> OC_SUBALB3 double precision, OC_SUBALB4 double precision, OC_SUBALB5
> double precision, OC_SUBALB6 double precision, MA_ARGYROP double
> precision, MA_ARGYRO2 double precision, MA_ARGYRO3 double precision,
> MA_ARGYRO4 double precision, MA_ARGYRO5 double precision, MA_ARGYRO6
> double precision, CULISETA_T double precision, CULISETA_2 double
> precision, CULISETA_3 double precision, CULISETA_4 double precision,
> CULISETA_5 double precision, CULISETA_6 double precision, CULISETA_N
> double precision, CULISETA_7 double precision, CULISETA_8 double
> precision, CULISETA_9 double precision, CULISETA10 double precision,
> CULISETA11 double precision, CX_ROTORUA double precision, CX_ROTORU2
> double precision, CX_ROTORU3 double precision, CX_ROTORU4 double
> precision, CX_ROTORU5 double precision, CX_ROTORU6 double precision,
> CX_ASTELIA double precision, CX_ASTELI2 double precision, CX_ASTELI3
> double precision, CX_ASTELI4 double precision, CX_ASTELI5 double
> precision, CX_ASTELI6 double precision, COQUILLETT double precision,
> COQUILLET2 double precision, COQUILLET3 double precision, COQUILLET4
> double precision, COQUILLET5 double precision, COQUILLET6 double
> precision, OCLEROTATU varchar(1), OCLEROTAT2 varchar(1), OCLEROTAT3
> varchar(1), OCLEROTAT4 varchar(1), OCLEROTAT5 varchar(1), OCLEROTAT6
> varchar(1), EXOTIC_SPE varchar(38))
> Error in db_execute_immediate()
>
> WARNING: Cannot create new table: 'create table from_mdb ( ID integer,
> ORGANISATI varchar(22), COLLECTOR varchar(32), SAMPLE_NUM
> varchar(29), DATE varchar(10), LOCATION varchar(50), GPSEAST
> double precision, GPSNORTH double precision, SITE_REFER
> varchar(50), PORT_SAMPL varchar(7), TRAP_ varchar(6), REASON_FOR
> varchar(14), SAMPLE_TYP varchar(7), HABITAT_CA varchar(46),
> SALINITY varchar(6), TEMPERATUR varchar(7), TOTAL_DIPS double
> precision, POS_DIPS double precision, TRAP_TYPE varchar(14),
> ATTRACTANT varchar(25), OC_CAMPTOR double precision, OC_CAMPTO2
> double precision, OC_CAMPTO3 double precision, OC_CAMPTO4 double
> precision, OC_CAMPTO5 double precision, OC_CAMPTO6 double
> precision, OC_ANTIPOD double precision, OC_ANTIPO2 double
> precision, OC_ANTIPO3 double precision, OC_ANTIPO4 double
> precision, OC_ANTIPO5 double precision, OC_ANTIPO6 double
> precision, OC_NOTOSCR double precision, OC_NOTOSC2 double
> precision, OC_NOTOSC3 double precision, OC_NOTOSC4 double
> precision, OC_NOTOSC5 double precision, OC_NOTOSC6 double
> precision, CX_PERVIGI double precision, CX_PERVIG2 double
> precision, CX_PERVIG3 double precision, CX_PERVIG4 double
> precision, CX_PERVIG5 double precision, CX_PERVIG6 double
> precision, CX_QUINQUE double precision, CX_QUINQU2 double
> precision, CX_QUINQU3 double precision, CX_QUINQU4 double
> precision, CX_QUINQU5 double precision, CX_QUINQU6 double
> precision, OC_AUSTRAL double precision, OC_AUSTRA2 double
> precision, OC_AUSTRA3 double precision, OC_AUSTRA4 double
> precision, OC_AUSTRA5 double precision, OC_AUSTRA6 double
> precision, OP_FUSCUS_ double precision, OP_FUSCUS2 double
> precision, OP_FUSCUS3 double precision, OP_FUSCUS4 double
> precision, OP_FUSCUS5 double precision, OP_FUSCUS6 double
> precision, OC_SUBALBI double precision, OC_SUBALB2 double
> precision, OC_SUBALB3 double precision, OC_SUBALB4 double
> precision, OC_SUBALB5 double precision, OC_SUBALB6 double
> precision, MA_ARGYROP double precision, MA_ARGYRO2 double
> precision, MA_ARGYRO3 double precision, MA_ARGYRO4 double
> precision, MA_ARGYRO5 double precision, MA_ARGYRO6 double
> precision, CULISETA_T double precision, CULISETA_2 double
> precision, CULISETA_3 double precision, CULISETA_4 double
> precision, CULISETA_5 double precision, CULISETA_6 double
> precision, CULISETA_N double precision, CULISETA_7 double
> precision, CULISETA_8 double precision, CULISETA_9 double
> precision, CULISETA10 double precision, CULISETA11 double
> precision, CX_ROTORUA double precision, CX_ROTORU2 double
> precision, CX_ROTORU3 double precision, CX_ROTORU4 double
> precision, CX_ROTORU5 double precision, CX_ROTORU6 double
> precision, CX_ASTELIA double precision, CX_ASTELI2 double
> precision, CX_ASTELI3 double precision, CX_ASTELI4 double
> precision, CX_ASTELI5 double precision, CX_ASTELI6 double
> precision, COQUILLETT double precision, COQUILLET2 double
> precision, COQUILLET3 double precision, COQUILLET4 double
> precision, COQUILLET5 double precision, COQUILLET6 double
> precision, OCLEROTATU varchar(1), OCLEROTAT2 varchar(1),
> OCLEROTAT3 varchar(1), OCLEROTAT4 varchar(1), OCLEROTAT5
> varchar(1), OCLEROTAT6 varchar(1), EXOTIC_SPE varchar(38))'
>
> _______________________________________________
> grass5 mailing list
> grass5 at grass.itc.it
> http://grass.itc.it/mailman/listinfo/grass5
More information about the grass-dev
mailing list