Re: pgsql-interfaces-digest V1 #180

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" 
> 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" 
> 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
> **************************************
> 
>