Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Re: NEW ODBC DRIVER

From: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
To: Byron Nikolaidis <byronn(at)insightdist(dot)com>
Cc: interfaces postgres <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] Re: NEW ODBC DRIVER
Date: 1998-05-12 11:02:43
Message-ID: Pine.LNX.3.96.980512102820.424B-100000@proxy.bazzanese.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
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'


In response to

Responses

pgsql-hackers by date

Next:From: Jose' Soares Da SilvaDate: 1998-05-12 12:17:56
Subject: Re: [INTERFACES] Re: NEW ODBC DRIVER
Previous:From: Ewan MellorDate: 1998-05-12 10:49:57
Subject: MS Access & PsqlODBC: Invalid field name 'name'

pgsql-interfaces by date

Next:From: Jose' Soares Da SilvaDate: 1998-05-12 12:17:56
Subject: Re: [INTERFACES] Re: NEW ODBC DRIVER
Previous:From: Ewan MellorDate: 1998-05-12 10:49:57
Subject: MS Access & PsqlODBC: Invalid field name 'name'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group