Viewing the SQL Version of a Query

When you create a query, it is converted to a SQL (Structured Query Language) statement. This statement is applied against the database. You can view the SQL version of a query, but you cannot modify the SQL statement.

Viewing the SQL statement for a query can be helpful in understanding how the query is working. This option can also be useful when you are attempting to write SQL for other parts of the program and want to see a sample of working SQL code.

To view the SQL version of a query

  1. Open Query Builder.
  2. Click View SQL.
  3. After viewing the SQL statement, close the dialog box.

Related Topics

Query Builder Conditions

Query Builder Overview



What's New in this Release


For a list of new features, see the What's New In This Release topic.

Contact us:

This documentation was developed by Infor CRM User Assistance. For content revisions, questions, or comments, contact the Infor CRM writers at