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.

Other Resources

 

Getting Started with Infor CRM Web Client

Infor CRM Quick Reference for the Web User

Getting Started with Infor CRM Back Office Extension

Contact us:

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