Received: from osage.gate.net (root@osage.gate.net [198.206.134.25])
	by hub.org (8.9.1/8.9.1) with ESMTP id KAA14661
	for <pgsql-interfaces@hub.org>; Thu, 7 Jan 1999 10:53:19 -0500 (EST)
	(envelope-from bill@hammondgroves.com)
Received: from Bill..hutto.com (tsver1-218.gate.net [199.227.29.218]) by
	osage.gate.net (8.8.6/8.6.12) with SMTP id KAA69884 for
	<pgsql-interfaces@hub.org>; Thu, 7 Jan 1999 10:53:06 -0500
Message-Id: <199901071553.KAA69884@osage.gate.net>
From: "Bill Hutto" <bill@hammondgroves.com>
Organization: Hammond Groves
To: pgsql-interfaces@hub.org
Date: Thu, 7 Jan 1999 10:52:30 +0000
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Re: pgsql-interfaces-digest V1 #180
Reply-to: bill@hammondgroves.com
Priority: normal
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
> **************************************
> 
>