在visual foxpro6.0中数据表分为----和-----两种?

4周前 (01-03 15:59)阅读14回复0
wojiukan
wojiukan
  • 管理员
  • 注册排名1
  • 经验值2808085
  • 级别管理员
  • 主题561617
  • 回复0
楼主

In VisuAl FoxPro 6.0, data tables can be classified into two types: free tables and database tables. In Visual FoxPro 6.0, the function recno() is used to get the current record number. The -project file's extension is .pjx. The command goto() means that the cursor points to the first record. The command skip() means that the cursor moves down one record. Visual FoxPro is Microsoft's database development software that was developed by the company. It is designed for small-scale database programming and allows you to create databases, table files, indexes, etc., as well as program in VB-like ways. It also supports features like XBase series on Windows, and it has been renamed from FoxBase to VisualFoxPro with Microsoft's acquisition of Fox Software. Currently, the latest version is VisualFoxPro 9.0, while classic VisualFoxPro 6.0 continues to be used in school teaching and education departments. When working on desktop-type database applications, its processing speed is very fast and is an indispensable tool for daily work. VFP can do various tasks such as creating databases, creating table files, indexing, etc., as well as programming in VB-like ways to achieve some management systems. The code for VFP 6.0 should be written using the following commands: Specifies the name of the database being created or opened (created dialogue box). Ignoring these parameters will open the Create dialogue box. The database file is saved with the extension .dbc.

Note: If the SET SAFETY command is set to ON and a database with the same name already exists at the user's specified path, Visual FoxPro will prompt the user to specify a different path or name for the database.

Explanation: When creating a database file (.dbc) alongside the associated database remark file (.dct) and index file (.dcx), regardless of whether the SET EXCLUSIVE setting is active or not, the database is opened in exclusive mode. Because the CREATE DATABASE creates the database after opening it, users do not need to issue another OPEN DATABASE command. Using CREATE DATABASE, even if "Project Manager" is open, the database does not automatically add to the project. To include the database in an application project, an explicit inclusion must be made, and only then will the project contain it.

Example: Creating a database named people.

Creating a table named friends with the following columns:

  1. FirstName (C(20))
  2. LastName (C(20))

Clear the display of tables and displays the information about the database tables. Display the database tables.

0
回帖

在visual foxpro6.0中数据表分为----和-----两种? 期待您的回复!

取消
载入表情清单……
载入颜色清单……
插入网络图片

取消确定

图片上传中
编辑器信息
提示信息