Search: execute-query

RCA.Activities.Core.ExecuteQuery Description This activity allows you to execute a query

can edit the name of the activity to organize and structure your code better. Eg: Execute Query

- Executes the query given in the SQL parameter. ・StoredProcedure - Invokes the procedure name specified

Execute Query

Execute Query

allows you to execute a query on a database and returns the query result in a Datatable. [[image:image

-20230419153435-1.png"]] * **Edit Query** - SQL command to be executed. This field must be completed according

. You can edit the name of the activity to organize and structure your code better. Eg: Execute Query

RCA.Activities.Core.ExecuteNonQuery Description This activity allows you to execute a non-query

Query - SQL command to be executed. This field must be completed according to the selection from

the dictionary. SQL Query (String)*- SQL command to be executed. This field must be completed according

Execute Non Query

Execute Non Query

" %) ((( RCA.Activities.Core.ExecuteNonQuery == **Description** == This activity allows you to execute a non-query statement on a database

Query** - SQL command to be executed. This field must be completed according to the selection from

are available: ・Text - Executes the query given in the SQL parameter. ・StoredProcedure - Invokes the procedure

supports entities imported from Data Service. Click to add filter, the Query Builder window opens Choose the condition to query. User can choose AND or OR From the first drop-down menu, select a field to filter

). The default value is False. As a result, if the field is blank and an error is thrown, the execution

[6] Query Entity Records

imported from Data Service. * Click to add filter, the Query Builder window opens ** Choose the condition to query. User can choose AND or OR ** From the first drop-down menu, select a field to filter

, the execution of the project stops. If the value is set to True, the execution of the project continues