LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I output database table info into a LabVIEW table or listbox?

Hi. I'm just starting out with the Database Connectivity toolkit, and I'm trying out output the data in a table in Access to a table or multicolumn listbox in LabVIEW. I can get the info properly output in a data cluster (I think that's the right term?), but I can't get it to output into a nicely formatted table. I've got the toolkit manual printed out, and there's an example (3-26) where they do exactly that, but it doesn't seem to work for me. Any help would be greatly appreciated.

Thanks.
seppo
0 Kudos
Message 1 of 3
(3,039 Views)
I don't have access at the moment to a computer that has the DCT on it, but as I recall, at somepoint you get out of a a 2D array of strings related to the columns and rows of the query you ran.

In any case, you can wire this array directly to a LV table indicator since a table is really just a fancy indicator for a 2D array of strings.

A multicolumn list box is equally easy to populate. In that case you simply create a property node for the indicator and pass the 2D array of strings to the "ItemNames" property.

Mike...

Certified Professional Instructor
Certified LabVIEW Architect
LabVIEW Champion

"... after all, He's not a tame lion..."

For help with grief and grieving.
Message 2 of 3
(3,039 Views)
Thanks for the Property Node note - I'd totally forgotten that they even existed.

Much appreciated.

seppo
0 Kudos
Message 3 of 3
(3,039 Views)