Tables Overview

This chapter shows you how to create and set up tables in VPM Enterprise. This Overview section briefly describes the Data Builder interface for  tables.

You manage your project's tables through the Database – Tables node or the Free Tables node in the treeview list on the List page of the Data Builder. 

The tables in a database are listed when the database is explanded.

You can create New tables, Add existing tables, access the Table Designer and Remove tables through the Data Builder.

When a table is selected and expanded, the fields in the table are listed.

When the Free Tables node is expanded, the application's free tables are listed.

The command buttons on the Data Builder allow you to create, modify and manage an application’s tables.  

·       When the Tables node under a database is selected, the New and Add buttons let you create new tables or add existing tables to the Data Builder.

·       When a table is selected, the Designer button opens the Visual FoxPro Table Designer for the table. Use the Table Designer to modify a table's structure and to create and modify indexes.

·       The Remove button removes the selected table from the Data Builder. You also have the option to delete the table files.

Table Names:  Consider using the VPM Enterprise file naming conventions for the tables you create for an application. If you adopt the VPM Enterprise file naming rules, your table files will be easily distinguishable from VPM Enterprise system table files, your tables will have application-specific names and your table names will help identify a table’s function in your applications.

Tip: VPM Enterprise uses the Data Builder info that you enter when you create and setup tables and views to help you build your application. At runtime, your application’s forms, administrative tools and utilities use the information you enter in the Data Builder. Therefore, the more completely you set up the Data Builder, the better VPM Enterprise and your application will perform.


Creating and Setting Up Tables - Overview