Search: insert-data-table
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Creator
- 39admin
- 7Tuan Nguyen
- 2Giang Tran
Last modification date
Creation date
Object type
Uploaded by
- 18Nhan Nguyen
- 13admin
- 7Tuan Nguyen
- 3VuNH54
- 2Giang Tran
- … 1 more
Upload date
Activities
Located in
- Rendered document content
Database Connect Database Disconnect Database Transaction Execute Non Query Execute Query Insert Data Table
- Raw document content
/view/Activities/Database/Activities/Execute%20Query/]] * [[Insert Data Table>>url:https://docs.akabot.com/bin/view/Activities/Database/Activities/Insert%20Data%20Table/]]
Data Table
Located in
- Rendered document content
The DataTable Activities belongs to Core Activities Pack. It contains several activities that enable the robots to manipulate data tables by adding or extracting information. See also: Release Notes Activities
- Title
Data Table
- Location
Data Table
- Raw document content
the robots to manipulate data tables by adding or extracting information. ))) See also: * [[Release Notes>>path:/bin/view/Activities/Data%20Table/%5B1%5D%20Release%20Notes/]] * [[Activities>>path:/bin/view/Activities/Data%20Table/Activities/]] ))) )))
非クエリを実行 (ja)
Located in
- Rendered document content
RCA.Activities.Core.ExecuteNonQuery 説明 このアクティビティでは、非クエリステートメントをデータベース上で実行します。UPDATE、INSERT
…できなくなります。 データプロバイダ名*:データベースへのアクセスに使用されるデータベースプロバイダの名前です。 例:“System.Data.SqlClient” 入力 パラメータ:SQLコマンドにバインドされている名前付き
…です。UPDATE、INSERT、DELETE文の場合、戻り値はコマンドが実行される行数です。他のコマンドの場合、戻り値は-1です。
- Raw document content
.ExecuteNonQuery == **説明** == このアクティビティでは、非クエリステートメントをデータベース上で実行します。UPDATE、INSERT、DELETE文の場合、戻り値はコマンドが実行される行数
…が設定されている場合、他のプロパティは設定できなくなります。 * **データプロバイダ名***:データベースへのアクセスに使用されるデータベースプロバイダの名前です。 例:“System.Data
…を呼び出します。 ・TableDirect:テーブルから全レコードを呼び出します。 **出力** * **影響があるレコード(整数)**:SQLコマンドの実行結果です。UPDATE、INSERT
Activities
Located in
- Rendered document content
Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel Insert Columns Table Excel Insert Or Delete Columns Excel Insert Or Delete Rows Excel Insert Rows Excel
- Raw document content
/Activities/Excel%20Activities/Activities/Excel%20Get%20Workbook%20Sheets/]] * [[Excel Insert Columns Table
…%20Table/]] * [[Excel Insert Or Delete Columns>>url:https://docs.akabot.com/bin/view/Activities/Excel
…Insert Or Delete Rows>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities
Create Bulk API Job
Located in
- Rendered document content
in the .csv file that contains the job data. By default, this property is set to COMMA. The following options
…in the .csv file that contains job data. File Path – The full path to the .csv file that contains the job data. Only String variables supported. Line Ending - Specifies the line ending which marks the end of a data
- Raw document content
for columns in the .csv file that contains the job data. By default, this property is set to **COMMA
…operations. The field values must also be found in the .csv file that contains job data. * **File Path **– The full path to the .csv file that contains the job data. Only String variables supported. * **Line Ending
Activities
Located in
- Rendered document content
Add Data Column Add Data Row Build Data Table Clear Data Table Filter Data Table For Each Row Generate Data Table Get Row Item Join Data Tables Look Up Data Table Merge Data Table Output Data Table Remove Data Column Remove Data Row Remove Duplicated Rows Sort Data Table
- Location
Data Table
- Raw document content
/Activities/Add%20Data%20Row/]] * [[Build Data Table>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Build%20Data%20Table/]] * [[Clear Data Table>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Clear%20Data%20Table/]] * [[Filter Data Table>>url:https://docs.akabot.com
[05]For Each
Located in
- Rendered document content
, data tables or other types of collections. (* for Mandatory) Properties Input Values (IEnumerable)*- Iterate through the data and process each piece of information individually. Able to input variable
…it, the data of this activity will be shown in the log. Be careful, consider data security before using
- Raw document content
" %) ((( RCA.Activities.Core.ForEach == **Description** == This activity allows you to loop through arrays, lists, data tables
…) == **Properties** == **Input** * **Values (IEnumerable)***- Iterate through the data and process each piece
…. E.g: [389861710] For Each < T > * **Public (Checkbox)** - If you check it, the data of this activity
データテーブルをクリア (ja)
Located in
- Attachment name
clear data table.jpg
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Core.ClearDataTable == **説明** == このアクティビティでは、指定されたデータテーブルをクリアできます。 [[[[image:clear data table.jpg]]>>attach:clear data table.jpg]] *は必須。 == **プロパティ** == **入力** * **データテーブル(DataTable)***:データをクリアするデータテーブル
- Location
Data Table
…Clear Data Table
データテーブルをマージ (ja)
Located in
- Attachment name
merge data table.jpg
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Core.MergeDataTable == **説明** == このアクティビティでは、あるDataTableと現在のDataTableをマージし、変更を保存するかどうか、および現在のDataTableに存在しないスキーマをどのように処理するのかを指定します。 [[[[image:merge data table.jpg]]>>attach:merge data table.jpg]] *は必須。 == **プロパティ
- Location
Data Table
…Merge Data Table
データテーブルを並び替える (ja)
Located in
- Attachment name
sort data table.jpg
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Core.SortDataTables == **説明** == このアクティビティでは、指定された列の値に基づいて、昇順または降順でデータテーブルを並べ替えることができます。 [[[[image:sort data table.jpg||class="img-thumbnail"]]>>attach:sort data table.jpg]] *は必須。 == **プロパティ** == **入力** * **データ
- Location
Data Table
…Sort Data Table
next page »
Page
1
2
3
4
5
RSS feed for search on [insert-data-table]