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@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))'
