DB Tools List Columns VI

Owning Palette: Utility VIs

Requires: Database Connectivity Toolkit

Lists the columns present in table. The column information includes the name, the data type, and the defined size of the column.

Example

	connection reference specifies a reference to an ADO Connection object.
	table specifies the name of the table to search.
	error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
	connection reference out returns a reference to an ADO Connection object.
	column information returns an array containing information about the columns in the database table. name returns the name of the column. database data type returns the type of data in the column. defined size returns the defined size of the column.
	columns returns an array of strings containing the names of each column in a database table.
	error out contains error information. This output provides standard error out functionality.

Example

Refer to the Get Database Information VI in the labview\examples\database directory for an example of using the DB Tools List Columns VI.