ado tool variant to string array

[bartb]

Hi

im working with the ADO tool. When in execute a query i get a variant output. But i like to have a string array output. I modified the Ado subvis, but the problem is that when i readout the string array the last cloumn is empty. Does someone knows howto conbvert the variant output to a string array?

thnx

[tst]

If you mean the DB toolkit, then it outputs a 2D array of variant. You need to wire it into 2 nested auto-indexed for loops and convert it inside.

[bartb]

thnx, i just solved the problem myself 😉 you can just use the variant to data and wire a 2d string array tot the type..

[tst]

Interesting.

At least in LV 7.0, you can only do that with the Variant to Data primitive and not with the DB Variant to Data primitive.

Must have been what threw me off.