Changes for page DB-Abfragen


From version 7.2
edited by gru
on 18.09.2023, 17:09
Change comment: There is no comment for this version
To version 7.3
edited by gru
on 18.09.2023, 17:10
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,6 +1,6 @@
1 1  {{content/}}
2 2  
3 -Database queries are similar to [[data sources>>doc:Sources]] (XML, CSV, JSON). The important difference is that they are not static, but read dynamically from a database. In principle, only queries or SELECT statements should be stored at this point. Other statements (INSERT, etc.) may work - but this varies from database type to database type and is not recommended. Instead, such statements should be made with the corresponding workflow action Database query.
3 +Database queries are similar to [[data sources>>doc:Sources]] (XML, CSV, JSON). The important difference is that they are not static, but read dynamically from a database. In principle, only queries or SELECT statements should be stored at this point. Other statements (INSERT, etc.) may work - but this varies from database type to database type and is not recommended. Instead, such statements should be made with the corresponding workflow action [[Database query>>doc:Formcycle.Designer.Workflow.Actions.SQLStatement]].
4 4  
5 5  {{info}}
6 6  Before you can create a new database query, you must create a [[database connection >>doc:DBConnections]] if you have not done so already.