ExecuteNonQuery

This activity is used to Insert, Delete, or update details to and from an existing table. The import data and the execute non-query activity performs the same functions. The difference is, the import data can be used to input data into a table without adding any condition. The execute non- query activity is used to do the same activity, with a specific condition.

Properties

INPUT

Location:*Specify the location of the database in which the table to be edited is present.

DBName:* Specify the name of the database in which the table is present.

Query:* Specify the query which has to be used to insert, delete or update the table

MISC

Display Name: Displays the name of the activity. You can also customize the activity name to help troubleshoot issues faster. This name will be used for logging purposes.

SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False.”
True: Continues to execute the workflow irrespective of any error thrown.
False: Stops the workflow if it throws any error

Version: It specifies the version of the Portable database feature in use.

OUTPUT

Result: Define a Boolean value to validate the success state of the activity.

*Represents mandatory fields to execute the workflow.