pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedMoney type mapping to VB5 Jet workspace
3+ messages / 3 participants
[nested] [flat]
* Money type mapping to VB5 Jet workspace
@ 1998-12-31 15:16 Bill Hutto <bill@hammondgroves.com>
0 siblings, 0 replies; 3+ messages in thread
From: Bill Hutto @ 1998-12-31 15:16 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Money type mapping to VB5 Jet workspace
@ 1998-12-31 21:58 Ken J. Wright <ken@ori-ind.com>
1999-01-01 05:29 ` Re: [INTERFACES] Money type mapping to VB5 Jet workspace Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Ken J. Wright @ 1998-12-31 21:58 UTC (permalink / raw)
To: pgsql-interfaces
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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Money type mapping to VB5 Jet workspace
1998-12-31 21:58 Re: [INTERFACES] Money type mapping to VB5 Jet workspace Ken J. Wright <ken@ori-ind.com>
@ 1999-01-01 05:29 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 3+ messages in thread
From: Thomas G. Lockhart @ 1999-01-01 05:29 UTC (permalink / raw)
To: Ken J. Wright <ken@ori-ind.com>; +Cc: pgsql-interfaces
> 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?
We are just getting a NUMERIC() type implemented now by Jan Wieck. We
haven't had a chance to try it out yet, but Jan is one of our best
developers so it is likely to be a good replacement for the less general
money type.
It isn't yet certain that the very first implementation of NUMERIC()
will allow one to omit the single quotes around values, but it probably
will.
Barring unforeseen problems, it should be available for v6.5.
- Tom
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-01-01 05:29 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-12-31 15:16 Money type mapping to VB5 Jet workspace Bill Hutto <bill@hammondgroves.com>
1998-12-31 21:58 Re: [INTERFACES] Money type mapping to VB5 Jet workspace Ken J. Wright <ken@ori-ind.com>
1999-01-01 05:29 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
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