The database closed, I learned that I learned VFP for half a year, I didn't want to learn when I started, because many people think that VFP did not have their future, in fact, the teacher said that there should be no "money map". Later, I opened this lesson in the school, and because of a medium in the original, I was interested in VFP. I have played a little experience in playing myself for a while. It is to talk about it is the database.
We all know that when a project is opened, then we use the Close Databases command to turn off the database's database, and cannot really turn off the database, just close all tables, views, and temporary tables in the database. For example, the following statement will result in a "file being used by errors": SET DATABASE to Data1Close DatabaseSUse (SYS (5) SYS (2003) DATA1) Therefore, it must be turned off before designing to truly close the database. So we must separate this program with the main program at runtime, establish an app separately, use it in an independent environment. This will reach the requirements. The above statement may have a question, is Data1 not a database? Should it open with the statement like Open Database MyData? That's right, however, VFP is a very flexible language that can even turn on the database and form as a table. What is the use of this? There are many use, such as our programming method for modifying the table structure / index, and finally you need to clean the database to use the modified result, you can open the database in the way you open the table, and then execute the Pack. In this way, it is possible to obtain details of the database in the database, refer to the connection between the intervals, and the connection between the intervals. Similarly, you can open the form in a way on the table. However, it is important to use this method that a complete path and file name must be used, for example, a "can't find alias myData" error, only after entering the full path information: Use data1Use C: / M Project /Data/mydata.dbc can open the database with the correct way to open the table
Things I have more useful skills, I hope everyone can have the benefits.
