VFP programming problems, ask the big guy for help 50

1. Basic knowledge of Visual FoxPro.

1. Basic concepts.

Databases, data models, database management systems, classes and objects, events, methods.

2. Relational databases:

1) Relational databases: relational models, relational patterns, relationships, tuples, attributes, domains, primary keywords, and external gateways.

Key words. 2) Relational operations: selection, projection, joining.

3) Consistency and integrity of data: entity integrity, domain integrity, referential integrity.

3. Visual FoxPro system features and working mode:

1) Features of the Windows version of the database.

2) Data type and main file type.

3) Various devices and guides.

4) Working mode: interaction mode (command mode, visual operation) and program operation mode.

4. Basic data elements of visual foxpro:

1) Constants, variables, expressions.

2) Common functions: character processing functions, numerical calculation functions, date and time functions, data type conversion functions, etc

Test the function. 2. Basic operation of Visual FoxPro database.

1. Establishment, modification and validity testing of databases and tables

1) Create and modify the table structure.

2) Browsing, adding, deleting, and modifying table records.

3) Create a database, add or remove tables from the database.

4) Set field-level rules and record rules.

5) Index of the table: primary index, candidate index, normal index, and unique index.

2. Multi-table operation:

1) Select a workspace.

2) Establish associations between tables: one-to-one associations; One-to-many associations.

3) Set referential integrity.

4) Join: Inner join; Outer joins: left join, right join, full join.

5) Establish temporary associations between tables.

3. Establish views and data queries

1) Creation, execution and modification of query files.

2) Create, view and modify the ** documents.

3) Create a multi-table query.

3. Relational database standard language SQL

1. SQL data definition function:

1） create table –sql

2） alter table –sql

2. SQL data modification function:

1） delete –sql

2） insert –sql

3） update –sql

3. SQL data query function:

1) Simple inquiry.

2) Nested queries.

3) Join queries.

4) Grouping and calculation queries.

5) Parallel operations of sets.

Visual FoxPro is referred to as VFP, which is a database development software launched by Microsoft, which is simple and convenient to use to develop databases.

Visual FoxPro originates from the database product FoxBase launched by Fox Software in the United States, which runs on DOS and is compatible with the XBase series.

FoxPro was originally an enhanced version of Foxbase, and after the latest version was released, Fox Software was acquired by Microsoft, developed to run on Windows, and renamed Visual FoxPro.

"VFP Programming" or VFP or Object-Oriented Database Management System for short will allow you to create an artistic enterprise database solution.

VFP is a powerful, interactive data management tool that allows you to create applications to get the most out of it. Mastering Visual FoxPro's object-oriented programming techniques as well as event-driven models can maximize the efficiency of programming.

VFP also provides an integrated system development environment, which not only supports procedural programming technology, but also has a powerful expansion in terms of language, supports object-oriented visual programming technology, and has powerful visual programming tools. At present, VFP is an ideal tool software for users to collect information, query data, create integrated database systems, and develop practical systems.

Basic Data Elements of Visual FoxPro:

1) Constants, variables, expressions.

2) Common functions: character processing functions, numerical calculation functions, date and time functions, data type conversion functions, and test functions.

VFP program design is a database file that realizes database modification, addition, deletion, query and other functions through VFP database software.

VFP Programming is a database management system software. Visual FoxPro is a powerful object-oriented environment designed for database structure and application development.

Information Technology and Programming (VFP Language)" is a public compulsory basic course for clinical medicine, pharmacy, pharmacy, laboratory and other majors. It is based on the basic skills of mathematics, physics, computer and other courses, and further cultivates and improves students' ability to master the basic theoretical knowledge of information technology and the ability to use information technology to deal with practical problems, so as to lay a solid foundation for subsequent study of related majors.

For students majoring in clinical medicine, pharmacy, pharmacy, and testing, the VFP language is a widely used programming language.

The main research content of VFP programming is the use of database management system, through the learning of this course and the training of experimental skills and design ability, emphasizing the combination of theory and practice, and improving the ability to analyze and solve problems.

To put it simply, it is a solution to solve a problem by applying the VFP programming language combined with the database.