Developer Network> Development Tools> Development Columns> VFP> Text
Visual FoxPro is a famous database management system software with a wide range of users. In the past, people's legend will not issue new versions since the 6.0 version, but Microsoft has made it a false word with a 7.0 version. Subsequently, there is no idea that the connection is issued with a version of 8.0 and version 9.0. The students in various universities in China have also followed the latest versions. In order to help the reader quickly master the application method of this software, Xiaobian specially organized this special lecture, its content is based on the speed, handle, and the results can be applied directly to the reader's work. Read navigation:
First, establish a "project"
Establishing a project is the first step in using this software. "Data Table" is referred to as Table in Visual FoxPro 9, which is a data information group contained in the database, and the project is a database and table and the various objects that use them.
examples
Second, establish a database
Each table in Visual FoxPro 9 belongs to one or more specific databases, and the user allows different databases to be established for different purposes, and naming and saving each database so that data is classified. management.
examples
Third, design table
After creating a project and database, you can create a table, which is an important part of using database software. Any database must contain a data table, otherwise it is useless. Data "table" is usually referred to as "table". In each database, there is a table including one or more associated tables, one table is a two-dimensional data structure consisting of rows and columns.
examples
Fourth, determine the field type
All Visual FoxPro data requires a classification, which is used to describe data possible values and values and size. Different types of data allow for use of different restrictions, which can specify the type and value range of each field within the allowable range.
V. Define fields
The first step of the creation table is to define the field, which needs to be done in the Table Designer, and the steps you can use are listed below.
examples
6. Browse data table structure
After completing the above operation, the screen will return to the Project Manager dialog. You can also see the field structure in the data table in this dialog.
examples
Seven, modify the table structure
For any data table, you can modify its field structure through Table Designer, such as the following operation, will add a new field.
examples
Eight, sort field
In the Table Designer dialog, you can also rearrange the order of the fields, thereby manipulating the display order of each column record in the data table, and its operational steps are listed below.
examples
Nine, renamed the table already existing
In the above operation, the created data table will be automatically saved in the hard disk, and if you want to rename the data table, you can operate according to the following steps.
examples
Ten, build data sheet using Table Wizard
Use the data table to quickly create a new data table on the existing data sheet. In the new data table, you can copy the fields and data types in the original reference data table, and the Table Wizard is used to complete the task to run it.
examples
postscript:
Create a data management system using Visual FoxPro 9, first create a project with a database, data table. "Project" is used to track all programs, forms, menus, databases, data sheets, reports, labels, query, and some other types of files required to create applications, which will be saved as a file in disk, extension PJX.
Table Designer and Table Wizard are the dialogs that are often used in this software. Visual FoxPro 9 provides a number of operation wizards that master the operation methods of Table Wizard, which will use the majority of these wizards, which will be confirmed in the later test.
