SQL Non-Query Activity

Description:

Executes a SQL INSERT, UPDATE or DELETE statement.

Inheritance Hierarchy:

System.Object
  System.Activities.Activity
    System.Activities.CodeActivity
      Geocortex.Workflow.Activities.SqlNonQuery

Function:

This activity allows you to perform parameterized edits to a database using an ADO.NET that is provided.

In a Workflow:

You would use this activity to perform a database edit such as to update the field value of a row in a database table.

Properties:

Name Description

In Arguments

Parameters

The parameters of the SQL statement.

When you configure the Parameters property, Workflow Designer opens a pop-up dialog where you enter the list of parameters. The parameters must agree with the Command Text parameters in name, type, and direction.

Misc

Command Text

The SQL command to issue. For example:

INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...)

UPDATE table_name SET column1 = value1, column2 = value2,... WHERE some_column = some_value

DELETE FROM table_name WHERE some_column = some_value

Command Timeout

The time in seconds to wait for the command to execute.

Connection Configuration Name

The name of the connection string specified in the application's configuration file (app.config or web.config) to use in order to open a database connection.

Connection String

The connection string to use in order to open a database connection.

Display Name

SqlNonQuery

You can change the name of an activity to one that describes what it does. A descriptive name can make a workflow easier to interpret and maintain.

Provider Name

The provider name that will be used to open a database connection.

Out Arguments

Rows Affected

The number of rows affected by the SQL statement.

Version Information:

Supported from: Geocortex Essentials 3.10.

© 2019 Latitude Geographics Group Ltd. All Rights Reserved.

Documentation Version 4.11