Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -1,12 +1,14 @@
	1	+{{figure image="sql_en.png" width="300" clear="h1"/}}
	2	+
1	1	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>>Formcycle.UserInterface.Data.DBConnections]]. The SQL statement may contain [[variables>>Formcycle.UserInterface.Variables]].
2	2
3	3	== Options
4	4
5		-* **Statement** The SQL statement to be executed.
	7	+; Statement
	8	+: The SQL statement to be executed.
6	6
7	7	== Note ==
8	8
9		-{{figure image="sql_en.png" width="300"/}}
10	10
11	11	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 ({{code language="none"}}'{{/code}}).
12	12