[AccessD] Credit Card Number..Scientific format

Does it help to treat it as text?


Thanks,

Liz 

-----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 4:01 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