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
- Open Query Builder.
- Click View SQL.
- After viewing the SQL statement, close the dialog box.
What's New in this Release
For a list of new features, see the What's New In This Release topic.
Getting Started with Infor CRM Web Client
Infor CRM Quick Reference for the Web User
This documentation was developed by Infor CRM User Assistance. For content revisions, questions, or comments, contact the Infor CRM writers at firstname.lastname@example.org.