Menu
▾
▴
[mdb-dev] Table problem
|
From: <ich...@ch...> - 2007-09-16 21:07:23
|
Hello,
i have a problem with mdb-tools pre1.
When i query the tables of the database using mdb-sql i get the data
with no problem, except for one table.
This table has 122 records on it but when i query it using mdb-sql
(or when i use mdb-export) i only get a row with a wierd number on
the first field of the first record.
am i doing something wrong here?
should i try the CVS version?
here are some relevant outputs:
$ mdb-export investigacion.mdb Proyectos
clavepro,titulo,financiamiento,fecha
aceptacion,IVigencia,FVigencia,fecha
termino,monto,linea,responsable,Descripci?
n,Nivel,Area,Objetivo,registro FZ,Finalizado,Colaboradores,informe
felipe,estudiantes doctorado,estudiantes maestria,estudiantes
licenciatura,localizacion,campo aplicacion,tipo de
proyectos,disciplina,BAJA,Motivo Baja
721420288,"","","","","","",,,,"","",,"","",0,"","",,,,"","","","",0,""
mdb-ver investigacion.mdb
JET4
DROP TABLE Proyectos;
CREATE TABLE Proyectos
(
clavepro Long Integer,
titulo Text (500),
financiamiento Text (100),
fecha aceptacion DateTime (Short),
IVigencia DateTime (Short),
FVigencia DateTime (Short),
fecha termino DateTime (Short),
monto Currency,
linea Long Integer,
responsable Long Integer,
Descripci?n Memo/Hyperlink (255),
Nivel Text (100),
Area Long Integer,
Objetivo Memo/Hyperlink (255),
registro FZ Text (100),
Finalizado Boolean,
Colaboradores Text (220),
informe felipe Text (100),
estudiantes doctorado Long Integer,
estudiantes maestria Long Integer,
estudiantes licenciatura Long Integer,
localizacion Text (100),
campo aplicacion Text (400),
tipo de proyectos Text (100),
disciplina Text (100),
BAJA Boolean,
Motivo Baja Memo/Hyperlink (255)
);
$ echo "select * from Proyectos" | mdb-sql /home/fz.uach.mx/data/
investigacion.mdb
+--------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
---------------------------------------------------------------------
+-----------------------------------------------------------------------
-----------------------------+--------------------
+--------------------+--------------------+--------------------
+------------+-------+-----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+-------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----
+-----------------------------------------------------------------------
-----------------------------+---------------------
+--------------------+------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----------------------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
-----------------------------+----
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------+
|clavepro|
titulo
|
financiamiento
|fecha aceptacion |
IVigencia |FVigencia |fecha termino |
monto |linea |responsable|Descripci?
n
|
Nivel
|Area |
Objetivo
|registro
FZ
|Finalizado|
Colaboradores
|informe
felipe
|estudiantes doctorado|estudiantes maestria|
estudiantes licenciatura|
localizacion
|campo
aplicacion
|tipo de
proyectos
|
disciplina
|BAJA|Motivo
Baja
|
+--------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
---------------------------------------------------------------------
+-----------------------------------------------------------------------
-----------------------------+--------------------
+--------------------+--------------------+--------------------
+------------+-------+-----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+-------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----
+-----------------------------------------------------------------------
-----------------------------+---------------------
+--------------------+------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----------------------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
-----------------------------+----
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------+
|
72142028|
|
|
| | |
| | |
|
|
|
|
|
|0
|
|
|
| |
|
|
|
|
|0
|
|
+--------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
---------------------------------------------------------------------
+-----------------------------------------------------------------------
-----------------------------+--------------------
+--------------------+--------------------+--------------------
+------------+-------+-----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+-------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----
+-----------------------------------------------------------------------
-----------------------------+---------------------
+--------------------+------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----------------------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
-----------------------------+----
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------+
1 Row retrieved
Thanks for your help.
|
