Loading float/decimal values with LoadFromDataset of UniLoader

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
DiamondMax
Posts: 1
Joined: Tue 07 Jul 2020 07:12

Loading float/decimal values with LoadFromDataset of UniLoader

Post by DiamondMax » Tue 07 Jul 2020 07:29

Hi!

I'm trying to load data from dataset (MS SQL) with UniLoader.LoadFromDataSet() method to MySQL table. It seems there is a problem with decimal values. When it encounters values like 123,4 in MS SQL column (type float) it reports that "column count does not match value count". Number of fields in dataset and in destination table is the same. I assume this is because of the comma in value. In destination table column type is decimal.

How can I workaround this?

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Loading float/decimal values with LoadFromDataset of UniLoader

Post by Stellar » Wed 08 Jul 2020 15:29

Unfortunately, we can't reproduce the issue. To investigate this behavior of UniDAC, please compose a small sample demonstrating the issue and send it to us, including database objects creating scripts.
You can send the sample using the contact form at our site: devart.com/company/contactform.html

Post Reply