![]() | 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 Object | Description |
---|---|
DB Tools Create Parameterized Query | Creates 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 Query | Executes 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 Data | Retrieves 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 Recordset | Retrieves 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 Data | Retrieves 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 Object | Frees 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 Value | Retrieves 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 Record | Moves 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 Record | Moves 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 N | Moves 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 Null | Returns a database variant that contains a NULL value. |
DB Tools Set Parameter Value | Sets 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. |
Helpful
Not Helpful