When you edit the SQL Query View in Domino Designer, a new event, SQL Query, appears in the programmer's pane, as shown in figure 11.
当在DominoDesigner中编辑SQL查询视图时，一个新的事件(SQL Query)将出现在编程窗格中，如图11所示。
The Query and View Designer updates the SQL statement in the SQL pane by adding or modifying the WHERE clause.
查询和视图设计器通过添加或修改WHERE 子句来更新 “SQL”窗格中的 SQL语句。
Tables and views are automatically added to the query when you reference them in the statement in the SQL pane.
当在“SQL”窗格的语句中引用表和视图时，这些表和视图将自动添加到查询中。
You can edit the current query directly in the SQL pane.
可以直接在“SQL”窗格中编辑当前查询。
Like View Designer, Query Designer has four panes: the Diagram pane, the Criteria pane, the SQL pane, and the Results pane.
如同[检视表设计工具]，[查询设计工具]有四个窗格：[图表]窗格、[准则]窗格、[SQL]窗格和[结果]窗格。
Therefore, if you add columns to the query output, the query and View Designer automatically adds them to the GROUP BY clause of the statement in the SQL pane.
因此，如果将列添加到查询输出中，则查询和视图设计器会自动将其添加到“SQL”窗格中语句的GROUPby子句中。
When you enter data using local-specific format in the Criteria pane, the Query and View Designer automatically translates it to ANSI format in the SQL pane.
当在“条件”窗格中以特定于本地的格式输入数据时，查询和视图设计器在“SQL”窗格中会自动将其转换为ANSI 格式。
If you manually add a query output column to an aggregate function in either the Criteria or SQL pane, the query and View Designer does not automatically remove other output columns from the query.
如果在“条件”窗格或“SQL”窗格中手动向聚合函数添加查询输出列，则查询和视图设计器不能自动从查询中移除其他输出列。
The SQL pane displays the SQL statement for the query or view.
SQL窗格：显示查询或检视表的SQL陈述式。
In addition, if you modify your query in the Criteria pane or Diagram pane, you might find that your SQL statement has been changed from what you entered.
另外，如果在“条件”窗格或“关系图”窗格中修改查询，可能会发现更改所得到的sql语句与所输入的语句不同。
As you build your query, the SQL pane automatically updates and reformats to be easily read.
生成查询时，“SQL”窗格将自动更新并重新格式化以便于阅读。
As you build your query, the SQL pane automatically updates and reformats to be easily read.
生成查询时，“SQL”窗格将自动更新并重新格式化以便于阅读。
应用推荐