Company Events Academic Community Support Solutions Products & Services Contact NI MyNI

DB Tools Set Properties VI

LabVIEW 2013 Database Connectivity Toolkit Help

Edition Date: June 2013

Part Number: 370016F-01

»View Product Info
Download Help (Windows Only)

Owning Palette: Utility VIs

Requires: Database Connectivity Toolkit

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.

Use the pull-down menu to select an instance of this VI.

Connection

connection reference specifies a reference to an ADO Connection object.
connection properties contains the following properties that define the database connection.
command timeout (s) specifies the length of time (in seconds) to wait in attempting to execute a command before quitting and returning an error. Setting this value to 0 instructs the VI to wait indefinitely.
connection string specifies the connection string that was used to make the database connection. This property is read-only.
default database is the default database to use for the connection. Some providers may not support this use of this property.
provider is the provider used to make the database connection. This property is read-only.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
connection reference out returns a reference to an ADO Connection object.
error out contains error information. This output provides standard error out functionality.

Command (CR)

command-recordset reference specifies a reference that combines an ADO Command object and an ADO Recordset object.
command properties specifies the following properties that define the most recent SQL query.
parameter count specifies the number of parameters. This property is read-only.
command text specifies the parameterized SQL command.
command timeout (s) specifies the length of time (in seconds) to wait in attempting to execute a command before quitting and returning an error. Setting this value to 0 instructs the VI to wait indefinitely.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
command-recordset reference out returns a reference that combines an ADO Command object and an ADO Recordset object.
error out contains error information. This output provides standard error out functionality.

Parameter (CR)

command-recordset reference specifies a reference that combines an ADO Command object and an ADO Recordset object.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
parameter properties contains the following properties that define the query parameters.
name specifies the name of the parameter. This property is read-only.
SQL data type specifies all the data types used in databases. Because each specific database application supports different data types, the options in this control have been condensed and named for the data types as they are represented in the LabVIEW Database Connectivity Toolkit.

0String (default)
1Long (I32)
2Single (SGL)
3Double (DBL)
4Date/Time
5Binary
direction specifies the direction of the parameter value.

0Input (default)
1Output
2Input/Output
3Return Value
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
command-recordset reference out returns a reference that combines an ADO Command object and an ADO Recordset object.
error out contains error information. This output provides standard error out functionality.

Command (C)

command reference specifies a reference to an ADO Command object.
command properties specifies the following properties that define the most recent SQL query.
parameter count specifies the number of parameters. This property is read-only.
command text specifies the parameterized SQL command.
command timeout (s) specifies the length of time (in seconds) to wait in attempting to execute a command before quitting and returning an error. Setting this value to 0 instructs the VI to wait indefinitely.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
command reference out returns a reference to an ADO Command object.
error out contains error information. This output provides standard error out functionality.

Parameter (C)

command reference specifies a reference to an ADO Command object.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
parameter properties contains the following properties that define the query parameters.
name specifies the name of the parameter. This property is read-only.
SQL data type specifies all the data types used in databases. Because each specific database application supports different data types, the options in this control have been condensed and named for the data types as they are represented in the LabVIEW Database Connectivity Toolkit.

0String (default)
1Long (I32)
2Single (SGL)
3Double (DBL)
4Date/Time
5Binary
direction specifies the direction of the parameter value.

0Input (default)
1Output
2Input/Output
3Return Value
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
command reference out returns a reference to an ADO Command object.
error out contains error information. This output provides standard error out functionality.

 

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
Add Comments 1 2 3 4 5 submit