|
»
»
Table problem
|
View:
New views
1 Messages
—
Rating Filter:
Alert me
|
 |
Table problem
by Iván Chavero Jurado
::
Rate this Message:
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. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ mdbtools-dev mailing list mdbtools-dev@... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
| Free Forum Powered by Nabble | Forum Help |