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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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'
From | Date | Subject | |
---|---|---|---|
Next Message | Jose' Soares Da Silva | 1998-05-12 12:17:56 | Re: [INTERFACES] Re: NEW ODBC DRIVER |
Previous Message | Ewan Mellor | 1998-05-12 10:49:57 | MS Access & PsqlODBC: Invalid field name 'name' |
From | Date | Subject | |
---|---|---|---|
Next Message | Jose' Soares Da Silva | 1998-05-12 12:17:56 | Re: [INTERFACES] Re: NEW ODBC DRIVER |
Previous Message | Ewan Mellor | 1998-05-12 10:49:57 | MS Access & PsqlODBC: Invalid field name 'name' |