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

Re: Float Percision with MS Access 97

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Calabrese <m2calabr(at)yahoo(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Float Percision with MS Access 97
Date: 2001-08-20 20:54:05
Message-ID: 10167.998340845@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
Michael Calabrese <m2calabr(at)yahoo(dot)com> writes:
> If I have a table with a float4 and it has greater
> precision that 4 to the left of the decimal point,
> Access will not let me change that record and gives me
> a write conflict.

You do realize that float4 only carries about six decimal digits of
precision on most machines?

> For example: if I have a table with the following

> Parts:
> PartID  Name   Price   Count
> 555     Tubing 2.50    101.123456

> MS Access seems to get the count from the ODBC driver
> as 101.1234.

And did well to get that, rather than 101.123.

Try float8 or numeric if you want more digits.

			regards, tom lane

In response to

Responses

pgsql-odbc by date

Next:From: Michael CalabreseDate: 2001-08-20 22:03:05
Subject: Re: Float Percision with MS Access 97
Previous:From: Ryan C. BonhamDate: 2001-08-20 20:02:55
Subject: RE: [ODBC] Re: Updating a view

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