[ mdbtools-Bugs-1602076 ] mdb-sql & mdb-export returning rows of NULL data

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

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV