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 Database VIs and function to access databases from LabVIEW.
With the Database VIs and function, you can perform the most common database tasks, including the following:
The VIs and function on this palette can return general LabVIEW error codes.
|Database Variant To Data||Converts a database variant to the LabVIEW data type specified in type so you can use the data in another function or VI.|
|DB Tools Close Connection||Closes a database connection by destroying its associated connection reference.|
|DB Tools Create Table||Creates a new table in the database identified by connection reference. The table and column information inputs describe the name of the table and the properties of each column in the table, respectively.|
|DB Tools Delete Data||Deletes data from a database identified by connection reference.|
|DB Tools Drop Table||Deletes the specified table from the database identified by connection reference.|
|DB Tools Insert Data||Inserts a new row into the table in the database identified by the connection reference.|
|DB Tools Open Connection||Opens a database connection using the connection information path and returns a connection reference. If prompt? is set to TRUE, LabVIEW displays a dialog box to set up the connection. Wire data to the connection information input to determine the polymorphic instance to use or manually select the instance.|
|DB Tools Select Data||Selects data from the table in the database identified by connection reference using the columns supplied in the columns array.|
|DB Tools Update Data||Updates the data in a database identified by connection reference.|
|Advanced VIs||Use the Advanced VIs to perform advanced database operations such as executing SQL statements and fetching data. You might need to use SQL when you use these VIs.|
|Utility VIs||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.|
© 1999–2010 National Instruments Corporation. All rights reserved.