Get Record Set from Database and Include Column Headers Using LabVIEW

[Softman]

Overview

This VI gets a Record set from database and include the column headers.

 
Description

This VI will return a Record set with the option to include the column names in the first row of a multidimensional string array created on the fly from the tables you wish to read.

Requirements

• LabVIEW 2012 (or compatible)

Steps to Implement or Execute Code

1. Change the Connection String, Table String and Selection String to your requirements.
2. Run the VI.

Additional Information or References
VI Snippet

**This document has been updated to meet the current required format for the NI Code Exchange.**

[hsalman]

Hi,

Is there a way to select the column headers after the query has been executed? For example, I am selecting data from different tables using JOIN, so my result would be different columns from separate tables. I want to be able to see the column headers.

[Softman]

Hi hsalman

'Get Column List' should contain what you need.