Viewing Data in Tables

  • Article

The quickest way to see the contents of a table is to look at it in a Browse window. The Browse window displays the contents of the table as a series of rows and columns you can scroll through. To familiarize yourself with some typical tables, you can browse the sample tables in the Visual FoxPro ...\Samples\Data directory.

To browse a table

  1. From the File menu, choose Open and select the name of the table you want to view.
  2. From the View menu, choose Browse.

You can also select the name of a table in the Project Manager, and choose the Browse button.

For example, open the Customer table in the Visual FoxPro ...\Samples\Data directory.

Table in a Browse window

For easier data entry, you can place a Browse window into Edit mode. In Edit mode, the column names are displayed on the left side of the window.

To change the Browse window to Edit mode

  • From the View menu, choose Edit.

    Table in Edit mode

In either mode, you can scroll through records, search for specific records, and make changes directly to the contents of the table.

Also, from the Project Manager, you can browse the contents of the tables in your project.

To browse a table from the Project Manager

  1. Select the Data tab.
  2. Select a table and choose Browse.

You can reuse your work from one project by sharing files with another project. The files are not duplicated, because the project stores only a reference to the file. Files can be associated with different projects simultaneously.

To share files between projects

  1. In Visual FoxPro, open the two projects that will share the file.
  2. In the Project Manager containing the file, select the file.
  3. Drag the file to the container for the other project.

See Also

Table Creation | Naming a Table | Deleting a Database Table | Working with Tables | Deleting a Free Table | Duplicating a Table | Renaming a Table | Customizing a Browse Window | Customizing Tables