Partager via


How to: View Records in Tables

You can view the records in a table by opening it in a browse window. A browse window displays data in a table as rows (records) and columns (fields) that you can scroll through. For more information, see Browse Window.

To browse data in a free table

  1. On the File menu, click Open.

  2. In the Open dialog box, browse to the location of the table you want to view.

  3. In the Files of type box, select the Table (*.dbf) file type to display only table files.

  4. Select the table file you want to view.

  5. On the View menu, click Browse.

    The table you selected opens in a browse window.

To browse data in a database table

  1. Open the database in the Database Designer.

  2. Select the table you want.

  3. On the Database menu, click Browse.

    The table opens in a browse window.

To browse data in a table from a project

  1. Open the project in the Project Manager.

  2. Expand the Data node and choose one of the following:

    • To browse a database table, expand the Databases node, then the Tables node.

    -OR-

    • To browse a free table, expand the Free Tables node.
  3. Click the table you want to view, and then Browse.

    The table you selected opens in a browse window.

To browse a table programmatically

  1. Open the table with the USE command.

  2. Follow USE with the BROWSE command.

    Tip

    To prevent users from adding records to a table while browsing a table, include the NOAPPEND clause in the BROWSE command.

For more information, see USE Command and BROWSE Command.

See Also

Tasks

How to: Navigate Records in Tables

How to: Filter Records in Tables

How to: Configure Browse Windows or Grids

Other Resources

Working with Records

Working with Tables (Visual FoxPro)