Advanced 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 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.

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

Palette ObjectDescription
DB Tools Create Parameterized QueryCreates a parameterized SQL query and returns a command reference that you must free eventually. Unless you are detecting the parameters automatically, the number of elements in the parameters array must match the number of parameters you specify in SQL query. For stored procedures, set stored procedure to TRUE and SQL query to the name of the procedure you want to execute.
DB Tools Execute QueryExecutes an SQL query and returns a recordset reference that you must eventually free with the DB Tools Free Object VI. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.
DB Tools Fetch Element DataRetrieves the data located at the column index of the current record in the recordset identified by the recordset reference. The column index can be either the zero-indexed position of the column in the recordset or the name of the column. Wire data to the type input to determine the polymorphic instance to use or manually select the instance.
DB Tools Fetch Next RecordsetRetrieves the next recordset in a multi-recordset query identified by recordset reference. When the current recordset is no longer available, the recordset reference is redirected to the new recordset. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.
DB Tools Fetch Recordset DataRetrieves the data in the recordset identified by the recordset reference input. You can convert each element in the array to its native LabVIEW data type using the Database Variant To Data function. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.
DB Tools Free ObjectFrees an object by destroying its associated reference and returns a different reference object. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.
DB Tools Get Parameter ValueRetrieves the value of the parameter specified by the parameter index input in the command or command-recordset. The parameter index can be either the zero-indexed position of the parameter in the command or the name of the parameter. Wire data to the type input to determine the polymorphic instance to use or manually select the instance.
DB Tools Move To Next RecordMoves the cursor to point to the next record in the recordset identified by the reference. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.
DB Tools Move To Previous RecordMoves the cursor to point to the previous record in the recordset. You cannot use this VI with a forward-only cursor. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.
DB Tools Move To Record NMoves the cursor to point to record n in the recordset. To move the cursor to the last record, set n to –1. You cannot use this VI with a forward-only cursor. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.
DB Tools NullReturns a database variant that contains a NULL value.
DB Tools Set Parameter ValueSets the value of the parameter at parameter index in the command or command-recordset. The parameter index can be either the zero-indexed position of the parameter in the command or the name of the parameter. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.

WAS THIS ARTICLE HELPFUL?

Not Helpful