Data from DB Tools Select Data

[jessica_kh]

Hi I have successfully created a set of database vi's, one accesses a complete entry using DB Tools Select Data and displays the retrieved information to the user as a variant.

However the data coming back includes "Value ->" All my DB data are strings and I have tried converting to string, but its is the DB Tools Select Data vi that seems to be producing this output

The code

The code is currently very neat and simple, I would hate to have to create a loop getting each value independently to create an array to display

Thank you for any help

Jessica

[PalanivelThiruvenkadam]

---

@jessica_kh wrote:

Hi I have successfully created a set of database vi's, one accesses a complete entry using DB Tools Select Data and displays the retrieved information to the user as a variant.

However the data coming back includes "Value ->" All my DB data are strings and I have tried converting to string, but its is the DB Tools Select Data vi that seems to be producing this output

The code

The code is currently very neat and simple, I would hate to have to create a loop getting each value independently to create an array to display

Code can be still Neat and Still simple, make sure No bending wires and Proper Flow from Left to right

---

 We cannot debug images better to attach codes (With Default Values to identify the issue), I hope once you convert the Variant to Desired datatype then the value will be removed.

[Yamaeda · Accepted solution]

The DB Tools Select data always returns data as a 2D array of variants, as to be able to handle any datatype. Just add a Variant to data and convert it to 2D array of strings, and it should work.

[jessica_kh]

Thanks yes that worked