Visual FoxPro |
Visual FoxPro is a data-centric object-oriented and procedural programming language produced by Microsoft. It is derived from FoxPro (originally known as FoxBASE) which was developed by Fox Software beginning in 1984; Fox Software merged with Microsoft in 1992 and the software acquired further features and the prefix Visual . The last version of FoxPro (2.6) worked under the Mac OS, DOS, Microsoft Windows, and Unix: Visual FoxPro 3.0, the first Visual version, dropped the platform support to only Mac and Windows, and later versions were Windows-only.
FoxPro is a member of the class of languages commonly referred to as xBase languages, which have syntax based on the dBase programming language. Other members of the xBase language family include Clipper programming language, dBase, and Recital (database). (A history of the early years of xBase can be found in the DBASE entry).
Visual FoxPro, also known as VFP is typically viewed by the general public as only a Database Managment System (DBMS). VFP is both a DBMS and a Programming Language and is mainly used to write desktop database applications running on Windows, but it can also be used to write fat client, Middleware, and web applications.
In late .
Rumors suggesting that Microsoft intends to end support for FoxPro have been common since Microsoft s acquisition of the product, despite the product having one of the longest [http://support.microsoft.com/gp/lifedevtoolfam support timeframes] for a Microsoft product (extended support until 2014). VFP 9 was released to manufacturing on December 17, 2004, and the Fox team is currently working on a project codenamed 90377 Sedna which will be built on top of the VFP9 codebase. Development for version 9 is still on going with a service pack due to be released at the end of 2005.
= Code samples =
Object loForm = CREATEOBJECT( HiForm ) loForm.Show(1)
DEFINE CLASS HiForm AS Form AutoCenter = .T. Caption = Hello, World ADD OBJECT lblHi as Label WITH; Caption = Hello, World! ENDDEFINE
Data handling *!* Create a table CREATE TABLE randData (iData I)
*!* Populate with random data using xBase and SQL DML commands FOR i = 1 TO 50 APPEND BLANK REPLACE iData WITH (RAND() * 100) INSERT INTO randData (iData) VALUES (RAND() * 100) ENDFOR
*!* Place an index on the data INDEX ON iData TAG iData CLOSE ALL
*!* Display sorted data using xBase commands USE randData SET ORDER TO iData GO TOP LIST NEXT 10 && First 10 (end-of-line comment) SKIP 81 LIST NEXT 10 && Last 10 CLOSE ALL
*!* Browse sorted data using SQL DML commands SELECT * from randData ORDER BY iData DESCENDING
For another sample, see the Visual FoxPro implementation of the [http://en.wikisource.org/wiki/Levenshtein_distance#Visual_FoxPro Levenshtein Distance] algorithm at WikiSource.
= Version information =
== Operating system compatibility ==
Supported Windows Versions Version VFP 6.0 VFP 7.0 VFP 8.0 VFP 9.0 Windows NT 4.0 Yes Yes No No Windows 95 Yes Runtime only No No Windows 98 Yes Yes Runtime only Runtime only Windows ME Yes Yes Runtime only Runtime only Windows 2000 Yes Yes Yes Yes Windows XP Yes Yes Yes Yes Windows 2003 Yes Yes Yes Yes Windows Vista Yes Yes Yes Yes
===Notes:===
# - VFP8 applications are not supported but can be run under WIndows NT 4.0 # - The free patch for VFP 9.0 has been created by the German FoxPro User Group (dFPUG) and is available at the dFPUG document portal in the directory http://portal.dfpug.de/dFPUG/Dokumente/Freeware/. It allows you to run VFP 9.0 applications on NT 4.0. # - The second-level menus don t work under Windows 95.
== Information on Executable Files ==
VersionVERSION() returnsEXE SizeEXE Date DLL SizeDLL Name
VFP 9Visual FoxPro 09.00.0000.2412 for Windows 5,620 kb13-DEC-2004 4,600 kbVFP9R.DLL
VFP 8Visual FoxPro 08.00.0000.3117 for Windows 5,236 kb25-SEP-2003 4,200 kbVFP8R.DLL
VFP 7Visual FoxPro 07.00.0000.9465 for Windows 4,260 kb04-JAN-2002 3,344 kbVFP7R.DLL
VFP 6Visual FoxPro 06.00.8961.00 for Windows 4,091 kb18-AUG-2000 3,295 kbVFP6R.DLL
VFP 5Visual FoxPro 5.0.0.344 4,072 kb20-AUG-1996 3,146 kbVFP500.DLL
VFP 3Visual FoxPro 03.00.00.0711 for Windows 4,374 kb16-DEC-1995 3,657 kbVFP300.ESL
FPW 2.6aFoxPro 2.6a for Windows 2,444 kb28-SEP-1994 n/an/a
= Beta code names =
= External links =
|
|