Summary

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

Details

Page properties

Title

...	...	@@ -1,1 +1,1 @@
1		-$services.localization.render("PT.Main.DatenbankSQLStatement")
	1	+SQL Statement

Content

...	...	@@ -1,14 +1,16 @@
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>>doc:Verbindung]]. The SQL statement may contain [[variables>>doc:Platzhalter]].
	1	+{{figure image="sql_en.png" width="300" clear="h1"/}}
2	2
	3	+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]].
	4	+
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="FCSnapshot35.png" width="300"/}}
10	10
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}}'{{/code}}).
	13	+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
13	13	(% style="color: rgb(56, 118, 29);" %)**Correct**
14	14