SQL Execute Query returns incomplete Dataset

[Tuluc]

I am currently facing an issue where my code is returning an incomplete result from the executed SELECT statement.

Only the first and last column is successfully returned while the columns inbetween are empty. 

When trying out the SELECT Statement in SQL Server Management Studio I get the complete data.

The Labview results on the other hand are imcomplete.

I was able to resolve this issue by changing the Cursor type at the "Execute Query" node to "dynamic". However, doing so resulted in a significant drop in performance which is why a new solution is needed.

[JensG69]

What's the data format of these columns?

Perhaps they are defined a unicode strings, don't know how LabVIEW handles these.

Regards, Jens

[FireFist-Redhawk]

Are all columns the same data type? Was your SQL query just "SELECT * from [table]" ?

You could try using "DB Tools Select Data.vi" as well. As a workaround and a troubleshooting step too.

[Tuluc]

Except for the first column all columns have varchar as their datatype

[FireFist-Redhawk · Accepted solution]

---

@Tuluc wrote:

Except for the first column all columns have varchar as their datatype

---

Did you use varchar<max>? Oddly enough it does not work with LabVIEW. At least in my case I get a bunch of spaces, the number of them equal to the number of characters in each varchar<max> record.

What do you get if you use Select Data.vi instead?

[Tuluc]

---

Did you use varchar<max>? Oddly enough it does not work with LabVIEW. At least in my case I get a bunch of spaces, the number of them equal to the number of characters in each varchar<max> record.

What do you get if you use Select Data.vi instead?

---

Yes, this seems to have been the problem. After limiting the datatypes the code now returns all results. 

Thanks a lot!