From: Sergio A. Kessler <ser@perio.unlp.edu.ar>
To: Ken J. Wright <ken@ori-ind.com>
Cc: Didier Gasser-Morlay <didierg@visualgroup.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC oin Windows
Date: Fri, 07 Jan 2000 00:20:46 -0300
Message-ID: <38755B8E.F74BA7E9@perio.unlp.edu.ar> (raw)
References: <3.0.32.20000106105502.009194e0@ren.cncware.com>
"Ken J. Wright" wrote:
>
> >1. Money type is seen has a float. Delphi complains when trying to post
>
> Use the decimal type from 6.5.x
>
> >2. Int8 is seen as a 17 byte string
> >3. float4 is seens as using 8 bytes (as float8)
>
> How are you viewing this data? Delphi provides casting methods
> (AsString,AsFloat,etc) to convert a fields raw data to an appropriate data
> type for your app.
>
> f := Dataset.FieldByName('SomeField').AsFloat;
if you are using Delphi, maybe you want to check the Export
utility in http://sak.org.ar, it takes any database supported
by the BDE and translate it to sql scripts (I've used it many
times to convert db's to Postgres)
and while we are on the subject, you may want to check mOdbc
http://perio.unlp.edu.ar/modbc (native odbc components for
Delphi and BCBuilder, no mo BDE)
I'm using it with Postgres for years now.
all of this is free software, of course ...
(beware, the connection is f* slow, as a adsl modem stopped
to work the past weekend, Y2K bug ?)
--
-= Sergio A. Kessler == http://sak.org.ar =-
You can have it soon, cheap and working; choose *two*.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ser@perio.unlp.edu.ar, ken@ori-ind.com, didierg@visualgroup.com
Subject: Re: [INTERFACES] ODBC oin Windows
In-Reply-To: <38755B8E.F74BA7E9@perio.unlp.edu.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox