ACCESS Procedure Reference

SUBSET Statement (Optional)

Adds or modifies selection criteria defined for a view descriptor.

Applies to:

view descriptors only

Syntax

SUBSET selection-criteria;

Details

The SUBSET statement specifies the selection criteria and ordering statement to be used by SYSTEM 2000 when creating a view descriptor. These statements are optional, but omitting them causes the view to retrieve all the data in the database. For more details about the default where-clause, see the discussion about WHERE clauses in Advanced Topics for Users. For example,

subset "where amount<1010";

Multiple selection criteria can be included in one SUBSET statement. The quoted strings are concatenated and passed to SYSTEM 2000 for processing. For example,

subset "where amount<1010"
       "ob amount";

To clear the selection criteria, submit the following statement:

subset;

For more information about SYSTEM 2000 where-clause and ORDER BY syntax, see the QUEST Language and System-Wide Commands, Version 12 manual.

Top of Page