I am using a SQL query to populate a Text ring. I need both IDs in the digital disply, and the item names in the text field of the Ring. So far I have always used my functions and SQL query to populate the data in a multicolumn list box, but I don't know how to do it in a ring. The reason behind this choice is to give the user the oppotunity to use a dropdown menu to choose one of the items, or if they know the item ID, type the ID in the ditial disply, and the corresponding item would show up for further functions. Can someone help me please? I have simplified my code in the screenshot below, but can't post the VI since it is sending query to my database. There is also a screenshot of the variant to multicolumn list box subVI that I am using.

The order inside your query must be the same as in the cluster constant. Try: SELECT Name, ID FROM Unitclass

ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

LabVIEW

Solved!

Author

Thanks @RamonG. This is exactly what I needed.

Seli6272@D

Message 11 of 11

(212 Views)