What is VFP?

VFP What is VFP?
Visual foxpro, which is Microsoft's Foxbase database software several times after FoxBase database software, and transplanted to Windows, the application development software is mainly used to develop data management and computing software.
Foxbase used command lines (in order to be compatible with the popular database software at the time ...), but the speed was faster than other database software at the time.
VFP is the latest visual database management system platform launched by Microsoft. It is a 32 -bit database management system with particularly powerful functions. It provides complete features, extremely friendly user interfaces, simple data access methods, unique cross -platform technology, and good compatibility, true compilation and strong security. Fast and most practical database management system software.
Visual FoxPro's growth road
Visual foxpro (hereinafter referred to as VFP) is a growing guy. The same tool language, but it is not a general development tool, but just focuses on the development of database applications.
, when VS.NET, who had the appetite of everyone's appetite, finally appeared in front of the developer, disappeared from VFP, which really caused a community in the development community. Don't VFP Microsoft? No, on the contrary, VFP can't stand the slow upgrade speed of VS, "single dry". The current VFP has been upgraded to version 9 and fully supports .NET technology.
In the following, let's pay attention to the growth path of VFP together to see that each upgrade VFP brings us those seductive new features. Of course, we only compiled the VFP 6.0 version, that is, VFP 7, 8, and 9. These contents come from MSDN Library Online. We only refer to the "What’ s New "section in each version of the VFP product documentation.
VFP 7
web services support VFP 7 to support registration and release of Web Services without using Microsoft SOAP Toolkit and VFP expansion to complete these tasks from the bottom;
Ter enhancement VFP 7 for the COM server for the COM server It has enhanced a large extent and can be operated with core platforms such as COM services;
XML supports the trend of transmitting data on Web in the form of XML. VFP 7 provides some functions for XML data and Foxpro Cursor or table conversion.
The various XBase feature VFP adds a lot of new or improved XBase features, and these features are written in VFP language;
Ole db provider can achieve the OLE DB Provider interface, and developers can be at any any of Support OLE DB programs and languages ​​to call VFP data. rn VFP 8rn n 数据特性增强VFP 8对其数据特性进行了改进，并增加了很多新的数据特性，包括：远程数据连接、创建类、自动增长域值、支持对照序列、 The hidden data conversion between the SQL statement SELECT… Union, insertion of the SQL Select command;
P other enhanced VFP 8 pairs of some tools, sample databases and solutions.
VFP 9
It data and XML enhanced the VFP during this period to strengthen its data characteristics. It is really dazzling to improve the project. For details, please refer to it here. R n The SQL language VFP 9 has been able to fully support the SQL query language;
The enhanced VFP 9 to enhance these designs: reports and tag designers, menu desigers, table desigers, query and view views The designer, data environment design device, and class and window desigers, etc.;
Ittae in other aspects, the same as VFP 8, VFP 9 has made a lot of improvements in other small details, making the developer's experience even more Comfortable.
of course, what mentioned above is only the corner of the iceberg brought by the new features brought by each version. In addition, it is not mentioned that the IDE (in VFP) and the language enhancement. This is the update of each version update. It will be improved and greatly improved. I believe that only the hardcore FOXER can be experienced. Although the improvements listed here seem to be very small, they have taken a huge space on the MSDN Library Online. Interested friends may wish to browse on the MSDN, and they can deeply understand why VFP will not die, and they can still be able Slocked.
VFP remote view and SPT application detailed explanation
The remote view (Remote Views) and SPT (SQL Pass Through) are two built -in solutions provided by VFP for the development of the Client/Server program. If you are more in -depth Applying VFP, the content of these two parts must be mastered.
Since the content is more, the article is divided into several articles several times. However, I personally think that the remote view and SPT are an inseparable whole. Although SPT is applied more, but if there is no in -depth understanding of the remote view, I don't think you can use SPT.
In this article: Programming Introduction Network // VFP/200705/977

If you refer to a certain software, it is generally: the abbreviation of Visual
FOXPRO, which is a programming environment, mainly focused on database development.
1, Microsoft Company acquired a FOX company, a database management software based on the Foxbase database.
The biggest advantage is that it is easy to learn and understand.
2, the biggest disadvantage is that the code cannot be dealt with directly with the bottom of Win, but is executed by the interpretation of the intermediate side. What can do can only be limited in the functions and functions that have been provided by the FOX environment.
3, the predecessor of VFP is DBase
II, which is still the age of DOS. Later from DOS to Win, after 9th generation, the VPF6.0 is WIN version. Around 2007, it was announced that
Visual
foxpro
stops research and development, VFP9
is the last official version.

Is a database