From: Bill Hutto <bill@hammondgroves.com>
To: pgsql-interfaces@hub.org
Subject: Re: pgsql-interfaces-digest V1 #180
Date: Thu, 7 Jan 1999 10:52:30 +0000
Message-ID: <199901071553.KAA69884@osage.gate.net> (raw)
In-Reply-To: <199901010414.XAA02014@hub.org>
Hi again,
Since my first Email apparantly went into the bit bucket, I thought
I'd try again. The following is a post from last year :). Perhaps
some one can give an authoratative answer.
Thanks,
Bill
> Date: Thu, 31 Dec 1998 15:16:59 +0000
> From: "Bill Hutto" <bill@hammondgroves.com>
> Subject: Money type mapping to VB5 Jet workspace
>
> Hi,
> I'm having problems with the mapping of the money type to an
> appropriate type in Visual Basic 5.0. Presently, it is coming across
> as type float8, and if that were acceptable to me, it isn't when I
> update, because I get an error '524':
>
> parser: attribute 'amount' is of type 'money' but expression is of
> type 'float8'
> You will need to rewrite or cast the expression.
>
> I can successfully update only with an ODBC direct workspace, where I
> can add single quotes around the value. I would prefer to be able to
> use the Jet workspace, however, as well as data bound controls.
> Is it possible to have it map to the currency data type?
>
> Thanks,
> Bill
>
> ------------------------------
>
> Date: Thu, 31 Dec 1998 13:58:31 -0800
> From: "Ken J. Wright" <ken@ori-ind.com>
> Subject: Re: [INTERFACES] Money type mapping to VB5 Jet workspace
>
> This is also a problem with the BDE & also with libpq. The odbc driver
> could/should? fix this, but then what about libpq? The docs say the money
> type is going away someday. Should we avoid using it? I believe a proper
> fix involves both the backend & frontends. Forcing quotes around a numeric
> value throws everyone off. Developer comments?
>
> Ken
>
> At 03:16 PM 12/31/98 +0000, you wrote:
> >Hi,
> > I'm having problems with the mapping of the money type to an
> >appropriate type in Visual Basic 5.0. Presently, it is coming across
> >as type float8, and if that were acceptable to me, it isn't when I
> >update, because I get an error '524':
> >
> > parser: attribute 'amount' is of type 'money' but expression is of
> >type 'float8'
> >You will need to rewrite or cast the expression.
> >
> >I can successfully update only with an ODBC direct workspace, where I
> >can add single quotes around the value. I would prefer to be able to
> >use the Jet workspace, however, as well as data bound controls.
> >Is it possible to have it map to the currency data type?
> >
> >Thanks,
> >Bill
> >
> >
>
> ------------------------------
>
> End of pgsql-interfaces-digest V1 #180
> **************************************
>
>
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: bill@hammondgroves.com, pgsql-interfaces@hub.org
Subject: Re: pgsql-interfaces-digest V1 #180
In-Reply-To: <199901071553.KAA69884@osage.gate.net>
* 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