Thread: ODBC vs decimal rounding
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.
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