Building SQL SELECT

After the user clicks Find, the system builds a SELECT statement with a WHERE clause. The SQL SELECT statement includes all columns in the BV. The WHERE clause includes any values in the QBE or filter fields. It can also contain values passed through Set Selection and Set Lower Limit system functions. The WHERE clause is then used to get all records that meet the criteria.

This diagram illustrates the information that appears in the runtime structures just before the system builds the SQL statement: