[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Trouble when updating Decimal type with ODBC/MySQL

Ju

9/10/2002 10:02:00 PM

Hi:
I'm using the ODBC.NET data provider to read MySQL tables into a DataSet via
an OdbcDataAdapter. I'm adding rows to the Dataset and I'm calling the
Update method on the OdbcDataAdapter to apply changes on the MySAL tables.
It works fine, but decimal part of Decimal Type fields are truncated :

E.g.: myDecimal = 2.005 will be 2.0000 in MYSQL Database (field format =
Decimal(10,4))

Any thoughts ?
Thanks
Julien