"Money" fields are returned as "float".

"Money" fields are returned as "float".

am 16.02.2011 03:07:29 von Vernon Cole

--001636c925357557d0049c5cbf32
Content-Type: text/plain; charset=ISO-8859-1

I ran across this while adding explicit PostgreSQL support to
adodbapi
..
I am using psqlodbc_09_00_0200 which I downloaded this morning.
When I store a field of type "money", which, IIUC, is stored in an exact
format, I get back from ODBC a double float.
This is very interesting, since I cannot use a floating value to input the
same field, and thus cannot perform a store of something I am about to
read.

In my humble opinion, you should be accepting and returning a decimal type.
--
Vernon Cole

P.S.: Is this the correct place to make this comment?

--001636c925357557d0049c5cbf32
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I ran across this while adding explicit PostgreSQL support to tp://sourceforge.net/projects/adodbapi/">adodbapi.
I am using psqlod=
bc_09_00_0200 which I downloaded this morning.
When I store a field of t=
ype "money", which, IIUC, is stored in an exact format, I get bac=
k from ODBC a double float.


This is very interesting, since I cannot use a floating value to input the =
same field, and thus cannot perform a store of something I am about to read=
..=A0

In my humble opinion, you should be accepting and returning a =
decimal type.


--
Vernon Cole

P.S.: Is this the correct place to make this comme=
nt?



--001636c925357557d0049c5cbf32--