Re: number/decimal field wrongly exported and altered column order

You might want to try a recent snapshot. There has been a number of change since 2005.
One is available there:
http://www.nirgal.com/mdbtools/debian.squeeze/


On Friday 22 July 2011 19:29:16 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,
> 
> 

------------------------------------------------------------------------------
BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts. 
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos & much more. Register early & save!
http://p.sf.net/sfu/rim-blackberry-1