Foxpro Website Links For
Visual Foxpro
 

Information About

Foxpro




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 and Recital . (A history of the early years of xBase can be found in the DBASE entry.)

Visual FoxPro, commonly abbreviated as VFP, is typically viewed by the general public as being merely a Database Management System ( DBMS ). This ignores the fact that it includes not only a DBMS Engine , but also a full-featured Programming Language . It can be used to write not just traditional Fat Client applications, but also Middleware and Web Application s.

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 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 Sedna which will be built on top of the VFP9 codebase and consist mainly of Xbase components that support a number of interoperability scenarios with various Microsoft technologies including SQL Server 2005, .NET, WinFX, Windows Vista, and Office 12. The development of Version 9 is ongoing with a service pack that was released December 8 , 2005 .
On March 1 , 2006 , Microsoft released a Community Technology Preview ( CTP ) of Sedna. According to the Fox team, the current plan "for releasing Service Pack 2 for VFP 9.0 will be sometime in 2007 , at the same time or near the same time of the release of Sedna".

In December 2005, VFP broke into the top 20 on TIOBE's Programming Community Index for the first time.


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

  • 1000000000)

  • 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

  • from randData ORDER BY iData DESCENDING


For another sample, see the Visual FoxPro implementation of the 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:










BETA CODE NAMES




EXTERNAL LINKS