Databases with Custom SQL Queries

Desktop Designer allows defining custom tables that are based on SQL queries. Two methods are available for creating a custom SQL query:

  1. Create a new SQL query.

    Go to Dynamic Data Manager > Database ConnectionTables and click Create new query in the Available tables field.

  2. Convert an existing database table into a query object.

    Go to Dynamic Data Manager > Table Configuration > SQL Tab and click the Edit SQL button. This converts the connected database into a Query object.

Note

This option is for experienced users only. If you make a mistake and create an invalid SQL statement, the query results become unpredictable. No data will be returned from the database or connection to the database will become impossible.

Note

This option is not available for text database files.

Insert a custom query into the edit field. Click OK when done.

Note

SQL statement field must not be left empty. An error appears if trying to continue without defining the statement.