[AccessD] Credit Card Number..Scientific format

You probably need to pull the data as "Text" instead of "Fixed".  Not
only is it rounding, but any leading zeros are being ignored.  (Don't
know if that's an issue with CC numbers, but for US postal codes it
definitely is.)

HTH

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, April 06, 2006 1:46 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Credit Card Number..Scientific format

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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com