VFP Tutorial - Data Tables

Creating a table

Click on the Data tab of the Project Manager then right-click on Free Tables

Select New File then New Table from the dialog that appears. This dialog allows you to start the Table Wizard which can be useful if your application matches one of the templates provided.

An explorer dialog will appear offering to create a table named 'Table1.dbf'. Change the name to 'CD.dbf' and save it in the same folder as the project manager file. A real life project typically has its files in a directory tree structure but we'll put all the files in the same folder here for simplicity.

The Table Designer will appear. Add the six fields from the list above and click OK when you have finished. Note that no size has been given for the Integer and Date fields, these are fixed by FoxPro.

The greyed-out fields on the right of the designer are only available for tables which are part of a database. You can leave the main route through the tutorial and go to this page to learn about Visual FoxPro databases.

Viewing the table

When you have closed the Table Designer you should see an entry like this in the status bar at the base of the screen:

This shows that the table named 'CD' is open, it's open for your exclusive use, and it holds no records.

Type:

in the Command Window to view the empty table.

Do not worry if the status bar is empty. If there is no table open when you type the command then Fox will display a directory tree and ask you to select a table.

Adding some records

Unlike Access, you cannot just create a new record by typing on a blank line in the grid. You have to select Append New Record from the Table menu. This menu pad appears whenever a Browse window is open on the desktop.

Do this three or four times and add some data to the table so that you will have something to work with when you design a form.

Introduction | Environment | Project | Tables | Forms | Navigation | Executable