Building Statements > Introduction
to the SQL Statement Builder > Parts of the SQL
Statement Builder Building Statements > Introduction
to the SQL Statement Builder > Parts of the SQL
Statement Builder The area on the right of the SQL Statement Builder contains one or more of the following tabbed screens depending on the type of statement being built: Query Specification, Criteria Logic, Group Criteria, New Values, and Call Parameters.
Query Specification – available with SELECT statements; allows you to select the column names in the statement to return, to sort on, and to specify simple criteria and conditions. For more information see the SELECT Statements section.
Criteria Logic – available with SELECT, UPDATE, and DELETE statements; reveals the criteria's structure by showing the criteria as a block diagram. Using the tab, you can manipulate the criteria in the statement. For more information, see the SELECT Statements, UPDATE Statements, and DELETE Statements sections.
Group Criteria – available with SELECT statements that have the Group Records Together option selected; determines the HAVING clause in the statement. For more information, see the SELECT Statements section.
New Values – available with INSERT or UPDATE statements; allows you to specify new values, nulls, or parameters for modifications to the database. For more information, see the INSERT Statements and UPDATE Statements sections.
Call Parameters – available with CALL statements; allows you to specify bind parameter names for a list of procedure parameter IDs. For more information, see the Executing Stored Procedures and Functions section.
Criteria Specification - available with UPDATE and DELETE statements; allows you to indicate a simple comparison criterion. For more information, see the UPDATE Statements, and DELETE Statements sections.