Received: from onondaga.gate.net (root@onondaga.gate.net [198.206.134.31])
	by hub.org (8.9.1/8.9.1) with ESMTP id PAA02576
	for <pgsql-interfaces@postgresql.org>;
	Thu, 31 Dec 1998 15:17:41 -0500 (EST)
	(envelope-from bill@hammondgroves.com)
Received: from Bill..hutto.com (txver2-123.gate.net [199.227.29.123]) by
	onondaga.gate.net (8.8.6/8.6.12) with SMTP id PAA126708 for
	<pgsql-interfaces@postgresql.org>; Thu, 31 Dec 1998 15:11:20 -0500
Message-Id: <199812312011.PAA126708@onondaga.gate.net>
From: "Bill Hutto" <bill@hammondgroves.com>
Organization: Hammond Groves
To: pgsql-interfaces@postgresql.org
Date: Thu, 31 Dec 1998 15:16:59 +0000
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Money type mapping to VB5 Jet workspace
Reply-to: bill@hammondgroves.com
Priority: normal

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