Re: [mdb-dev] number/decimal field wrongly exported and altered column order

[Jakob E. <jab...@gm...>]

The problem with decimals has been discussed on the mailing list before:
 http://sourceforge.net/mailarchive/forum.php?thread_name=4DA2EF69.7000602%40fibernetics.ca&forum_name=mdbtools-dev
I have posted a patch, but I don't know if my bugfix has been integrated into the main repository yet. you can download the mdb tools source from my fork on github at https://github.com/jakob/mdbtools/tree/mdbviewer

Re Column Ordering: I think the mdb tools export columns in the order that they are stored internally.  When you alter a column, the original column is marked as deleted and a new column is appended. Try repairing/compacting the database (in Access) to restore the proper column order when using mdb-export.

Best regards,
Jakob


On 22.07.2011, at 21:29, Seb wrote:

> Hi,
> 
> I'm using version 0.5.99.0.6pre1.0.20051109-7.1 (Debian sid), and
> noticed that a field with type Number, field size Decimal, Precision 3,
> and scale 0, shows fine in MS Access.  Some rows:
> 
> -2
> -1
> 2
> 3
> 
> mdb-export exports as:
> 
> 002
> 001
> 002
> 003
> 
> If I change the field properties in MS Access to Number, field size
> Double, then mdb-export exports properly.  However, the column order in
> the output gets altered, with the modified column being output last.
> This causes some problems for scripting.
> 
> Is this a bug?
> 
> Cheers,
> 
> -- 
> Seb
> 
> 
> ------------------------------------------------------------------------------
> 10 Tips for Better Web Security
> Learn 10 ways to better secure your business today. Topics covered include:
> Web security, SSL, hacker attacks & Denial of Service (DoS), private keys,
> security Microsoft Exchange, secure Instant Messaging, and much more.
> http://www.accelacomm.com/jaw/sfnl/114/51426210/
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev