From: SourceForge.net <no...@so...> - 2006-11-24 03:16:24
|
Bugs item #1602076, was opened at 2006-11-24 16:16 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1602076&group_id=2294 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Mike (snowflynz) Assigned to: Nobody/Anonymous (nobody) Summary: mdb-sql & mdb-export returning rows of NULL data Initial Comment: After successfully installing mdbtools 0.6pre1, I tested things by running some queries on a table that has 14 rows of data in it. However, mdb-sql returns the 14 rows, but with nothing (NULL) in them. See: 1 => select * from Cash_Rates 2 => go +-------+--------------------+----------+----------+----------+--------+--------------------+ |G_Code |E_Date |DailyRate |MvgAvg7 |AvgMat |Modified|ModDate | +-------+--------------------+----------+----------+----------+--------+--------------------+ | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | +-------+--------------------+----------+----------+----------+--------+--------------------+ 14 Rows retrieved The same happens with mdb-export: root@jaguar# mdb-export ***.mdb Cash_Rates G_Code,E_Date,DailyRate,MvgAvg7,AvgMat,Modified,ModDate ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" All data is being returned as NULL, even though the correct number of rows are being reported. Result of mdb-ver: root@jaguar# mdb-ver ***.mdb JET4 Here's the schema of that table: DROP TABLE Cash_Rates; CREATE TABLE Cash_Rates ( G_Code Long Integer, E_Date DateTime (Short), DailyRate Double, MvgAvg7 Double, AvgMat Double, Modified Boolean, ModDate DateTime (Short) ); System: root@jaguar# uname -srm FreeBSD 6.1-RELEASE-p7 i386 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1602076&group_id=2294 |