Company Events Academic Community Support Solutions Products & Services Contact NI MyNI

Utility VIs

LabVIEW 2013 Database Connectivity Toolkit Help

Edition Date: June 2013

Part Number: 370016F-01

»View Product Info
Download Help (Windows Only)

Owning Palette: Database VIs and Function

Requires: Database Connectivity Toolkit. This topic might not match its corresponding palette in LabVIEW depending on your operating system, licensed product(s), and target.

Use the Utility VIs for a variety of operations, including getting table and column information, getting and setting database properties, formatting data and time data, performing database transactions, and writing and reading data files.

The VIs on this palette can return general LabVIEW error codes.

Palette ObjectDescription
DB Tools Database TransactionBegins, commits, or rolls back a transaction for any type of reference. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.
DB Tools Format Datetime StringReturns a string containing the formatted date and time, and identifies the string as a date/time string so other VIs can interpret this string. Wire data to the input of this VI to determine the polymorphic instance to use or manually select the instance.
DB Tools Get PropertiesGets properties of the object as determined by the inputs. This VI works for connections, commands, recordsets, columns, and parameters. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.
DB Tools List ColumnsLists the columns present in table. The column information includes the name, the data type, and the defined size of the column.
DB Tools List TablesLists the tables in the database identified by connection reference.
DB Tools Load Recordset From FileLoads a recordset from a file and returns a recordset reference that identifies this recordset. You can retrieve data from this recordset like any other recordset, but some properties might not be available on this recordset.
DB Tools Save Recordset To FileSaves the recordset identified by the recordset reference to either an XML or ADTG file. The ADTG file format is a proprietary format that only the LabVIEW Database Connectivity Toolkit can interpret. The ADTG format results in a smaller file than the XML format. You can reload both formats into LabVIEW using the DB Tools Load Recordset From File VI.

Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.
DB Tools Set PropertiesSets properties on the object as determined by the inputs. Wire data to the reference and properties inputs to determine the polymorphic instance to use or manually select the instance.

 

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
Add Comments 1 2 3 4 5 submit