Follow-On Topics

Related Topics

# Adding Predicates

The Predicates dialog box is displayed when the Predicates icon is selected in the toolbar and is used to insert a predicate in the SQL statement generated. The dialog box supports the standard SQL predicates but also makes provision for proprietary predicates to be used for drivers that implement them. The dialog box contains the following:
|  | ALL — Indicates that the query should return all query results as opposed to other predicates that restrict the query results. This predicate is included largely for completeness as almost all OLEDB or ODBC drivers assume the ALL predicate if no other predicate is used.
|  | DISTINCT — Removes duplicate rows taking into account only those columns that are requested in the query.
|  | DISTINCTROW — Removes duplicate rows taking into account all columns in the source for the tables requested in the query, irrespective of the columns that are actually requested in the query.

|  | TOP — Indicates that the query should only return the percentage of rows specified, starting from the top of the result set. The behaviour of the option depends on how the query is sorted as to which rows are returned.

|  | TOP — Indicates that the query should only return the number of rows specified, starting from the top of the result set. The behaviour of the option depends on how the query is sorted as to which rows are returned.

|  | Other predicate — Allows another predicate statement to be manually entered. Such statements are inserted after any standard predicates selected.

Copyright © 2018 Quadrant Software B.V. All rights reserved.