From: Ken J. Wright <ken@ori-ind.com>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Money type mapping to VB5 Jet workspace
Date: Thu, 31 Dec 1998 13:58:31 -0800
Message-ID: <3.0.32.19981231135827.00796e40@ori-ind.com> (raw)
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
>
>
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: ken@ori-ind.com
Subject: Re: [INTERFACES] Money type mapping to VB5 Jet workspace
In-Reply-To: <3.0.32.19981231135827.00796e40@ori-ind.com>
* 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