Execute SQL
Use this step to execute a SQL statement on the selected database. You can change records in your database using SQL commands, such as create, update, insert, delete, drop, and so forth. You can also execute stored procedures using the call command, for example call add_record("name"). To read records from your database, use the Query Database step. To store data in a database, use the Store In Database step.
Properties
Configure the Execute SQL step using the following properties.
- Database Mapping
- Select a database mapping from the mappings specified in the Call Robot step.
- SQL Statement
- Type a SQL statement to execute on the selected database.
The robot does not evaluate the statement you type. Check your SQL statements beforehand or you can check the validity of the statement just by executing the step.
Do not delete or modify tables in a database used by the Store In Database or Execute SQL steps.
- Changed Rows
- If selected, you can specify a variable of integer type to get the number of rows changed by the SQL statement as the step output.