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 - DATABASE SELECTION
Activity «Database selection» can be found in section «SQL».
Activity executes the database query and gets the table as a result (DataTable)
Activity executes the database query and gets the table as a result (DataTable)
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
Table from selection; Out; DataTable; *; Table with query results.
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.