Thread: ODBC vs decimal rounding

ODBC vs decimal rounding

From
Francisco Reyes
Date:
I am using the PostgreSQL ODBC client, 7.001.009, with Visual Foxpro 6. I
am retrieving a real column and when I get it to Foxpro it is rounded to 2
decimal points. Is there a way to get 3 instead?

The data on the Postgresql is saved to 3 decimal points.

I didn't see any settings on the ODBC client for this and I am wondering
whether it is an ODBC issue or a Foxpro issue.



Re: ODBC vs decimal rounding

From
tony
Date:
On Fri, 2002-05-03 at 23:03, Francisco Reyes wrote:
> I am using the PostgreSQL ODBC client, 7.001.009, with Visual Foxpro 6. I
> am retrieving a real column and when I get it to Foxpro it is rounded to 2
> decimal points. Is there a way to get 3 instead?
>
> The data on the Postgresql is saved to 3 decimal points.
>
> I didn't see any settings on the ODBC client for this and I am wondering
> whether it is an ODBC issue or a Foxpro issue.

"Foxpro arises from the dead and innundates popular open source database
list with support requests"

This is a client issue

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html