| 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
| 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 |