SQL Expression Reference

The Infrastructure AdministratorSQL Assistant simplifies the creation of SQL select statements. In all dialog boxes where you can enter a SQL statement, you can use the SQL Assistant, for example, when you create a label definition. In the Form Designer, you use the SQL Assistant when defining control properties that require SQL statements.

SQL Assistant facilitates the entry of table names, attribute names and relations. It provides context specific information about the current industry model, such as valid parameters. For example, you can list tables, views, feature class attributes, and feature relations, and explore the values are actually stored in the database. Click or double-click to add the values to the SQL expression, so that no misspellings occur.

For examples of SQL scripts for Oracle, SQL Server, and SQLite, view the sample scripts that are provided under <infrastructure_administrator>\Data\SQLSheet.

Before saving the select statement, you can validate the syntax.

Use the SQL Assistant in the following components and tasks:

• Report Designer
• Form Designer
• Defining tracing conditions
• Feature Search
• Explorer Configurator
• Creating label definitions and defining rules for label regeneration
• Defining Intersections