Labview Database Connection Toolkit and decimal point

[MarcoMauri]

Hi,

on my system I use "," (comma) as decimal point.

In Labview Options I unflagged "Use localized decimal point", and numeric controls and indicators use "." (dot) as decimal point.

The problem is that Labview Database Connection Toolkit keeps returning floating point numbers as strings with comma as decimal point.

Has anyone experienced this issue?

Is this related to Labview or MySQL ODBC Connector (that I'm using to connect to a mySQL DB)?

Thanks in advance for any help,

Marco

[mikeporter]

You have two or three places to look. First there is the DCT. Second, there's a couple layers there that could cause problems (the mySQL drivers and ADO) and then there's even the posibility that the issue could be in the DBMS itself.

I would start by burrowing down through all the DCT layers and find the spot where the results are actually being read back fromt he database. If the resutls are read as variants and converted to LV datatypes, the problem is on the LV side. If the values are being read as strings and converted, the problem coiuld be on the other side.

Mike...

[MarcoMauri]

thanks for replying Mike.

Here's a snapshot of my code:

When fetching data, in the probe position "1" I get  "Value -> 500.000E-3".

Note that the decimal separator seen in this probe is indipendent from the setting "Use localized decimal point". It's alwayst dot.

To display the data I convert them to a 2D string array, and that's where dots are converted to commas: in position 2 I get "0,5" - with a comma decimal separator, regardless the option mentioned above.

At this point the issue seems related to Labview...

Thanks again,

Marco