Utility VIs
- Updated2023-02-21
- 2 minute(s) read
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 Object | Description |
|---|---|
| DB Tools Database Transaction | Begins, 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 String | Returns 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 Properties | Gets 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 Columns | Lists the columns present in table. The column information includes the name, the data type, and the defined size of the column. |
| DB Tools List Tables | Lists the tables in the database identified by connection reference. |
| DB Tools Load Recordset From File | Loads 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 File | Saves 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 Properties | Sets 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. |