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
> 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
pgsql-odbc by date
|Next:||From: Michael Calabrese||Date: 2001-08-20 22:03:05|
|Subject: Re: Float Percision with MS Access 97 |
|Previous:||From: Ryan C. Bonham||Date: 2001-08-20 20:02:55|
|Subject: RE: [ODBC] Re: Updating a view|