From: JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>
To: "'asif(at)petstore(dot)com'" <asif(at)petstore(dot)com>
Cc: "'pgsql-interfaces(at)hub(dot)org'" <pgsql-interfaces(at)hub(dot)org>
Subject:
Date: 1999-07-01 19:16:18
Message-ID: 01BEC3D4.AD2F64C0.jt-kirkpatrick@mpsllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

>Subject: bug: Access sees money types incorrectly

it's the odbc -- it doesn't recognize the money type. i have had to use
int4, storing all entries *100 (i.e. 35.99 as 3599), and then on reports be
sure to divide by 100. DON'T use float4!! in postgres6.5 i understand the
newer numeric type is available, but i don't know if the odbc can use it
yet. . .

jt

Responses

  • Re: at 1999-07-01 21:51:43 from S. Asif Hassan

Browse pgsql-interfaces by date

  From Date Subject
Next Message Wayne 1999-07-01 19:56:19 Help with pgaccess!
Previous Message Tommaso Parisi 1999-07-01 17:08:29 JDBC and Applet on Linux-Apache