Page Tree
Other Releases
...
A query is a request for data or information from a database table or a combination of tables. This data may be generated as results returned by the Structured Query Language (SQL) or as pictorials pictorial (graphs or complex results, e.g.) trend analyses from data-mining tools.
...
This alternative uses the same statement as presented beforeshown above, but in a different location. Instead of writing it in a Tasktask/Class class or CodeBehind, it can be placed directly into Edit > Datasets > Queries > SqlStatement Column.
...
The last option is to use a feature called a SQL Query Builder, found at Edit>Datasets. It is a graphic interface that facilitates the creation of SQL Statements based on a specific provider. This method is not as usual as the others, so more details regarding its functionalities will be explained below.
...