Insert/Update/Delete action

Use the Insert/Update/Delete action in the Database package to execute an INSERT, UPDATE, or DELETE statement from the database.

Settings

In the Session name field, enter the name of the session that you used to connect to the database server in the Connect action.
In the Statement field, enter the SQL statement to insert, update, or delete the records.
- Use an INSERT statement to create new records in a table:
```
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...)
```
- Use an UPDATE statement to modify a record:
```
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition
```
- Use a DELETE statement to remove a record:
```
DELETE FROM table_name WHERE condition
Example: DELETE FROM Persons WHERE LastName='Smith'
```
In the Timeout for the query in seconds field, specify the time within which the statement execution should stop, even if the execution is not completed.
If you do not enter a value in the Timeout for the query in seconds field, then the default timeout specified in the driver library is used.