SQL Expression Reference

The Infrastructure Administrator SQL 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.

Note: SQL Assistant is specific to the condition in which it is started. For general purposes, use SQL Sheet (the standalone version of SQL Assistant).

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

Note: To use the SQL Assistant, you must be familiar with Oracle or SQL Server, SQL, and the industry model . These subjects are not covered here.