[mdb-dev] Truncated numbers

[Rob P. <ro...@el...>]

I'm having a little difficulty with mdbtools truncating some numbers.  In
the underlying Access 2002 database, some currency data is being truncated.
For example, a figure of £133,950.00 is being processed by mdbtools as
£33,950.

mdb-schema identifies the field as 'Currency (8)'.  Unfortunately I don't
have Access 2002, so can't advise what the correct field definition is.  But
the reported field length seems to be too short.

I'm using version 0.5.  Is this perhaps a known problem fixed in the CVS
version?

Thanks,

Rob

--
Rob Pomeroy: ro...@el...
Solicitor specialising in charity law, wills, probate and trusts
Ellis & Co. Solicitors, 10 Castle Street, Chester, CH1 2DS
Telephone: 01244 319388; Fax: 01244 319333