[AccessD] Credit Card Number..Scientific format

Thumbscrews on the Informix DBA. A CC number is a string of digits not a 
mathematical entity.

As soon as you move into a double it will truncate and round.
and a double can only have 15 significant digits due to the fixed size 
of  the mantissa and exponent.
If you can find out the data type on the Informix side that might help, 
maybe you can force into a Currency
datatype that allows 19 significant digits or even a Decimal datatype 
declared as a Variant subtype.
If not read into a 4 byte text string and do a lot of bit twiddling.

Mark A Matte wrote:

>Hello All,
>
>I'm using A97 to pull from an Informix db over ODBC.  The field I'm dealing 
>with stores credit card information.  The problem is it comes in Scientific 
>notation...if I try to pull as fixed...it works except for the 16 digit card 
>numbers...it rounds the last 2 digits up or down?
>
>Any suggestions?
>
>Thanks,
>
>Mark
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada