SQL statements

Previous Next

To access data, in addition to using data sources, you can also code SQL statements manually at page level.

SQL statements give you extra flexibility and manageability. They can be used to define extra queries for special purposes that are only relevant locally. On the downside, SQL statements require coding work and this coding work cannot easily be re-used at other levels than the web GUI level.

Before you start coding SQL, always ask yourself if you cannot reach your goal simply by using SQL properties.

 

 

collapseCreating a SQL Statement
collapseExecuting the SQL Statement as an HTML event

 

 

See Also

Data Sources

SQL-related Properties