|DbType||"DbType" is the database type. This input is usually loaded from configuration variables.|
|ConnectionString||"ConnectionString" is the connection string to the database. This input is usually loaded from configuration variables.|
|FileName||"FileName" is the name of the database table on which we would like to run the Upsert.|
|Keys||The Keys create the WHERE Clause of the query. The keys are concatenated to form the following pattern:
The AndOr values determine the order in which the keys are run. ANDs are always evaluated before ORs. This is similar to the way a BinaryDecision service works.
This is the container node that contains all the Key nodes. It does not accept any input, but you can Right-Click to add new Keys (Key#0, Key#1, etc.). Each Key below this node is built into the query as a Where Clause.|
|Key||Once EASYProcess builds each Key it will have the following format: [Column] [Operator] [Value]. Whether or not the Value is encased in single quotes is determined by the selected Type.
"Key" is a container node which accepts no input but represents a single Key that can contain information related to a key. Each Key node is indexed.|
|And||"AndOr" is used when we are dealing with more than one key. Valid values are "And" and "Or". If this value is left blank it defaults to "And".
The AndOr values determine the order in which the keys are run. ANDs are always evaluated before ORs.|
|Column||The column to be referenced from the table in the query.|
|Operator||The operator to be used in the Key.|
|Type||This is the data type of the "Value". This determines whether the "Value" is encased in single quotes.|
|Value||The value which we will compare against the "Column" of the this Key.|
|Values||The "Values" are all the updates/inserts against the table that will occur.
This is the container node that contains all the "Value" nodes. It does not accept any input, but you can Right-Click to add new Values (Key#0, Key#1, etc.). Each Value below this node is built into the update statement.|
|Value||A "Value" specifies both the column name and the value to be updated/inserted in that column in the upsert.
"Value" is a container node which accepts no input but represents a single Value that can contain information related to a Value. Each Value node is indexed.|
|Column||The column in the table the value will be updated.|
|Type||This is the data type of the "Val". This determines whether the "Val" is encased in single quotes.|
|Val||This is the actual data which is updated/inserted in the specified column.|
|CommandTimeout||"CommandTimeout" is the timeout for query in milliseconds. After this time the service cancels execution of the query and throws an error.|