非クエリを実行

「非クエリを実行」アクテビティについてです。※現在ナレッジ準備中です

1.アクティビティのプログラム名

RCA.Activities.Core.ExecuteNonQuery

2.説明

Studio バージョン 2.0.3.0~

Executes an non query statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1.

データベース上でクエリ以外の文を実行します。UPDATE、INSERT、およびDELETE文の場合、戻り値はコマンドによって影響を受ける行の数になります。その他のすべてのタイプのステートメントでは、戻り値は -1 です。

3.プロパティ

プロパティ一覧のみ掲載します。
※システム内部で保有しているプロパティを記載している場合があり、コボットStudio画面内で確認不可のものが一部ございます。ご了承ください。

AffectedRecords　・・・　The result of the execution of the sql command. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1.

ContinueOnError　・・・　Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False).

ExistingDbConnection　・・・　An already opened database connection obtained from the Connect or Start Transaction activities. This property and the ConnectionString and ProviderName properties are mutually exclusive; if this property is set, the others can no longer be set.

Sql　・・・　SQL command to be executed. This field must be completed according to the selection from the CommandType property.

CommandType　・・・　Specifies how a command string is interpreted. The following options are available: Text - Executes the query given in the SQL parameter. StoredProcedure - Invokes the procedure name specified in the SQL parameter. TableDirect - Invokes all records from a table.

DisplayName　・・・　The display name of this activity. You can edit the name of the activity to organize and structure your code better.

Parameters　・・・　A dictionary of named parameters that are bound to the sql command. The binding is done by specifying the '@parameterName' statement in the sql command. At runtime the parameterName will be replaced with its value from the dictionary.

4.使い方

準備中