Displays the number of rows in a specific table that satisfy
selection criteria in an Access Definition. This command is available
during an edit or browse session, a Point-and-Shoot session, and an
Extract File or Archive File browse session.
COUNT [table]
- table
- Name of the table for which a row count is to be
displayed.
- During an edit or browse session, the table can
be indicated by positioning the cursor in the window containing the
selected table, explicitly naming the table, or specifying the identifier
Tn or Vn. If a table is not specified, the lowest-level displayed
table is assumed in columnar mode and the current table in sidelabels.
- The COUNT command is useful when the number of eligible
rows in the database exceeds the maximum number of fetch rows. You
can use the MAX FETCH command to respecify the limit or you can respecify
the selection criteria to obtain a smaller set of rows.