ODBC vs decimal rounding

Started by Francisco Reyesalmost 24 years ago2 messagesgeneral
Jump to latest
#1Francisco Reyes
lists@natserv.com

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.

#2tony
tony@animaproductions.com
In reply to: Francisco Reyes (#1)
Re: ODBC vs decimal rounding

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