Executes an SQL query and returns a Command-Recordset reference.
Reference to an ADO Command object. Use a Command object to query a database, return records, execute bulk operations, and manipulate data within a database.
Method used to navigate the Recordset. Some providers and databases do not support all cursors.
Name | Description |
---|---|
forward-only | Allows only forward movement through the recordset. You cannot see changes made by other users during navigation. |
keyset | Allows forward and backward navigation. You can see records that other users add. Records deleted by other users, however, will not be removed. |
dynamic | Allows forward and backward navigation. You can see all changes other users make to the database. |
static | Allows forward and backward navigation with no ability to see any changes that other users make during navigation. |
Default: forward-only
Error conditions that occur before this node runs.
The node responds to this input according to standard error behavior.
Standard Error Behavior
Many nodes provide an error in input and an error out output so that the node can respond to and communicate errors that occur while code is running. The value of error in specifies whether an error occurred before the node runs. Most nodes respond to values of error in in a standard, predictable way.
Default: No error
Number of records to cache in local memory.
Each time you request next records, the node removes the current set of records from local memory and the retrieves the next set. If the cursor type input is set to forward-only, you must use the default cache size of 1. If you select a different cursor type, you can set the cache size to any value greater than 0.
Default: 1
A reference that combines an ADO Command object and an ADO Recordset object. Use a Recordset object to read and manipulate data from databases.
Error information.
The node produces this output according to standard error behavior.
Standard Error Behavior
Many nodes provide an error in input and an error out output so that the node can respond to and communicate errors that occur while code is running. The value of error in specifies whether an error occurred before the node runs. Most nodes respond to values of error in in a standard, predictable way.
Where This Node Can Run:
Desktop OS: Windows
FPGA: Not supported
Web Server: Not supported in VIs that run in a web application