Aktionen - SQL Statement 

Page / - last modified by gru on 30.04.2021, 16:12 

SQL Statement 
last modified by gru
on 30.04.2021, 16:12

Table of Contents
Options
Note

 
Actions of type Database query allow you to write custom SQL queries and execute them against a database. The database connection must have been setup in the database connection menu. The SQL statement may contain variables.
Options
Statement
The SQL statement to be executed.
Note
The statement will be executed as a so called prepared statement, which prevents SQL injection attacks. You do not need to use simple quotation marks (').
Correct
insert into test_tabelle (firstName, lastName) values ([%tfFirstName%], [%tfLastName%])
Wrong
insert into test_tabelle (firstName, lastName) values ('[%tfFirstName%]', '[%tfLastName%]')