The ACCESS Procedure for PC Files
SUBSET Statement
Adds or modifies selection criteria for a view descriptor.
| Note: | for DBF, DIF, WK1, WK3, WK4, Excel 4, Excel 5, and Excel 95 file formats under Windows operating environments view descriptor |
Details
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.
CAUTION:
An editing
statement, such as SUBSET, must follow the CREATE statement when you
create a view descriptor.
See "CREATE Statement" for
additional information.