Search: set-web-attribute-1

RCA.Activities.Core.BuildDataTable Description This activity allows you to create a new Data Table with different settings. In the body of activity Data Table - Click to add/ remove columns, update column name/ column type Properties Misc Public (Checkbox) - Check if you want to publicize

settings. [[[[image:build data table.jpg||class="img-thumbnail"]]>>attach:build data table.jpg

[[image:image-20230419142900-1.png||height="299" width="422"]] == **Properties** == **Misc** * **Public

RCA.Activities.Core.JoinDataTables Description This activity allows you to add different data from different tables using common values with each other. (* is mandatory) In the body of activity Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable

"]]>>attach:join data table.jpg]] (* is mandatory) == **In the body of activity** == **Join Table Wizard - **set join condition and join type** ** [[image:image-20230419151628-1.png]] == **Properties** == **Input

. By default, this check box is selected (set to True).

-20220505135914-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path** - The path

are also extracted. By default, this check box is selected (set to True). ))) {{velocity

of InterOp.Excel._Application's properties to be set and their values Macro setting (DropDownList) - Specifies

Excel Macro settings Read Only (Checkbox): Opens the specified workbook in Read-Only mode. Selecting

for Excel Activities. [[image:image-20220505111836-1.jpeg]] (* for mandatory) == **In the body

of InterOp.Excel._Application's properties to be set and their values * **Macro setting (DropDownList

the current Excel Macro settings * **Read Only (Checkbox)**: Opens the specified workbook in Read-Only mode

Configure Connection - Set connection string, data source, data provider. Edit Query - SQL command

and the ConnectionString and ProviderName properties are mutually exclusive; if this property is set, the others can no longer be set. Provider Name* - The name of the database provider used to access the database. E.g

-20220506105340-1.png]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set

/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Edit Query** - SQL command to be executed. This field must be completed according

affected by the command. For all other types of statements, the return value is -1. (* for Mandatory) In the body of activity Configure Connection - Set connection string, data source, data provider. Edit

exclusive; if this property is set, the others can no longer be set. Provider Name*- The name

. For all other types of statements, the return value is -1. [[image:image-20220506105309-1.png]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data

/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Edit

) In the body of activity Configure Connection - Set connection string, data source, data provider. Data

is set, the others can no longer be set. Provider Name* - The name of the database provider used

, the activity will fail and all the written rows will be saved. [[image:image-20220506105511-1.png]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data

/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Data

. If UseTransaction is set to true, the contained operations are executed in a single transaction and applied at the end if none of them failed. If UseTransaction is set false, all operations are committed individually

a DatabaseConnection variable. (* for Mandatory) In the body of activity Configure Connection - Set connection

that can perform multiple transactions with the database. If UseTransaction is set to true, the contained

. If UseTransaction is set false, all operations are committed individually. When this activity ends, the connection to the database is closed. This activity returns a DatabaseConnection variable. [[image:image-20220506105232-1

RCA.Activities.Core.DatabaseConnect Description This activity allows you to connect to a database by using a standard connection string. (* for Mandatory) In the body of activity Configure Connection - Set connection string, data source, data provider. Properties Connection Configuration

of activity** == **Configure Connection **- Set connection string, data source, data provider. [[image:image-20230419153435-1.png]] == **Properties** == **Connection Configuration** * **Connection String (String