Menu
PIX RPA
STUDIO
ROBOT
PIX Master
BASIC ACTIVITIES
COLLECTIONS
CAPTCHAS
CLIPBOARD
WINDOWS CREDENTIAL
WINDOWS
SAP
FILES
GOOGLE DRIVE
GOOGLE SHEETS
GOOGLE DOCS
HTTP
OFFICE
WINDOWS PROCESSES
MACHINE LEARNING
MESSENGERS.TELEGRAM
WEB
Robot examples
Меню
SQL - TRANSACTION
Activity «Transaction» can be found in section «SQL».
Activity could be used to change the data within database without DataSet usage by executing UPDATE, INSERT or DELETE instructions.
Activity could be used to change the data within database without DataSet usage by executing UPDATE, INSERT or DELETE instructions.
Click on the image to enlarge it.
Option; Description
Ready Connection; Use existing database connection
Connect to a new connection; Build new database connection
Property; Class; Type; Options; Description
Ready Connection; In; Activities.DataBaseSQL. DataBaseShareMethodConnection; Ready Connection; Ready Connection.
Connection string; In; String; Connect to a new connection; Database connection line.
Provider name; In; String; Connect to a new connection; Database connection provider name.
Base request; In; String; *; Text of database query.
Timeout; In; Int32; *; The time in seconds to wait for the command to execute.
Parameter List; In; BR.Core.ExpressionArguments; *; Parameters used in the database query.