Money type mapping to VB5 Jet workspace - Mailing list pgsql-interfaces

From Bill Hutto
Subject Money type mapping to VB5 Jet workspace
Date
Msg-id 199812312011.PAA126708@onondaga.gate.net
Whole thread Raw
List 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


pgsql-interfaces by date:

Previous
From: Dave Page
Date:
Subject: RE: [INTERFACES] ODBC DRIVER v06-40-0002
Next
From: "Ken J. Wright"
Date:
Subject: Re: [INTERFACES] Money type mapping to VB5 Jet workspace