Message-Id: <35585E94.3AC79FF3@insightdist.com>
Date: Tue, 12 May 1998 10:37:08 -0400
From: Byron Nikolaidis <byronn@insightdist.com>
Mime-Version: 1.0
To: "Jose' Soares Da Silva" <sferac@bo.nettuno.it>
Cc: interfaces postgres <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Re: NEW ODBC DRIVER
References: <Pine.LNX.3.96.980512102820.424B-100000@proxy.bazzanese.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

This sounds like a different problem.  I have tested money columns and at least I
can see the data.  Since the driver must convert the money type into a numeric,
maybe it is having trouble with your type of money.  Didn't you say that you are
not using dollars?

Byron

Jose' Soares Da Silva wrote:

> On Mon, 11 May 1998, Byron Nikolaidis wrote:
>
> >
> >
> > Jose' Soares Da Silva wrote:
> >
> > > I have a problem with types.
> > > I created a table with a column of type money and another with type
> > > bool, Access translate money to numeric (double precision) and bool to
> > > text.
> > > I thought that Access recognized this types as Money and Yes/No.
> > > Is it an ODBC or a PostgreSQL problem ?
> > >                                                          Thanks, Jose'
> >
> >
> > In my tests, Access never bothered to retrieve the information returned by
> > the driver which says that the field is a MONEY type.  I chose to make it a
> > numeric, but I could make it character, which would allow you to see the
> > money symbols, but I'm not sure if you could perform calculations on it?
>
> Numeric should be OK, but Access doesn't read the data on money fields.
> Access displays the word "#deleted" on the field instead of data.
>
>                                                           Jose'