Changes for page Datenbank (SQL Statement)
Change comment:
There is no comment for this version
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