microsoft.public.dotnet.framework.odbcnet

Dvoøák Josef

10/22/2002 1:14:00 PM

Hi I found a solution of this problem:
on MSDN WWW
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/...
dbcjetdata_type_limit.asp)
Drivers does not support DECIMAL, so i replaced it by DOUBLE
(OdbcDataType.Double) and it´s works perfectly.

Josef Dvorak


"Ju" <truc@noos.fr> wrote in message
news:3d7e5dc8$0$20681$79c14f64@nan-newsreader-01.noos.net...
> 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
>
>