Fetched data doesn't appear in MCL

[ijan]

Hi all...i've been strugle for this in a few days. i try to fetch data from a database and store it to MCL, it has two column and my problem is only one column is appear in MCL, the concat query won't appear. i try the query in phpmyadmin and it gives me a correct result also in labview when i activate highlight execution i can see the query give #6x2 result thats mean the output is correct. i can't figure out what is the problem???

[ramses64]

Hi,
i've seen this problem, and solved it by using "Database Data To Varian" for each column returned.
In fact, when you cast your 2D data directly to 2D string, some data is lost.
You have to cast each column separatly, regarding to the data they contains.

I hope this will solve your problem.
Best Regards...

[ijan]

i'm using labsql not database connectivity toolkit so there is no database data to variant vi. i try anything to variant but its not working.

[ramses64]

Why don't you use the Database connectivity toolkit ?

[Dennis_Knutson]

I use LabSQL but I don't recognize the first function you are using.

ramses,

Why would you want to use the toolkit when a free version exists?

[smercurio_fc]

I would suggest changing your SQL query to STR(SUM(actual_cost) ... This will make sure that both columns are strings, which is what the MCL expects.

[ramses64]

Hi Dennis,

I thought the Database Connectivity Toolkit was included in Professional version...