Re: [INTERFACES] Re: NEW ODBC DRIVER

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'