ODBC oin Windows

From: Didier Gasser-Morlay <didierg(at)visualgroup(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: ODBC oin Windows
Date: 2000-01-06 09:39:51
Message-ID: 387462E7.E46F3B4A@visualgroup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I have downloaded and happilly installed the odbc driver for Windows
from insightdist.com

I am using Delphi 4 SP3 on Windows NT 4 SP3 and I have the following
questions/problems

1. Money type is seen has a float. Delphi complains when trying to post
a float into a money
2. Int8 is seen as a 17 byte string
3. float4 is seens as using 8 bytes (as float8)

4. Since the money type is not recommended, I was planning to store
money amount in int8 forcing the number of decimals to a known number.
Since delphi sees int8 as a string this makes life a bit tricky,
especially doing calculations. How do you store large money amounts (4
bytes when you store e.g. italian Lira or Spanish Pesetas is a bit
small)

Any ideas ?

Didier

--
--------------------------------------------------------------------------------------------
Any views or opinions are solely those of the author and do not
necessarily
represent those of Visual Communications Group or its principal
operating
divisions (FPG, Telegraph Colour Library, Planet Earth Pictures,
Colorific!, Pix, Giraudon, Bavaria Bildagentur).
--------------------------------------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which
it is addressed, and may contain confidential and/or privileged
material.
If you are not the intended recipient of this message, please do not
read,
copy, use or disclose this communication; and please notify the sender
immediately. It should be noted that any review, retransmission,
dissemination or other use of, or taking action in reliance upon, this
information by persons or entities other than the intended recipient is
prohibited.
--------------------------------------------------------------------------------------------

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2000-01-06 09:50:50 RE: [INTERFACES] query java object?
Previous Message Tim Kane 2000-01-06 07:46:52 ECPG and sqlda