Previous Page | Next Page

The ACCESS Procedure for PC Files

SUBSET Statement


Adds or modifies selection criteria for a view descriptor.
Valid: for DBF, DIF, WK1, WK3, WK4, Excel 4, Excel 5, and Excel 95 file formats under Windows operating environments
Applies to: view descriptor

SUBSET <selection-criteria>;


Details

You use the SUBSET statement to specify selection criteria when you create a view descriptor. This statement is optional. If you omit it, the view retrieves all data (rows) in the PC file.

An editing statement, such as SUBSET, must follow the CREATE statement when you create a view descriptor.

See the CREATE Statement.

Previous Page | Next Page | Top of Page