Stack Overflow
Stack Overflow

Questions tagged [visual-foxpro]

Questions tagged with Visual Foxpro should be specifically about the Windows based versions of Foxpro, from 3.0 through the final 9.0 version. Earlier versions, and the versions for the Mac and SCO Unix are not "Visual", and shouldn't be tagged as such, nor should the tag Foxpro be included on questions about Visual Foxpro.

Visual FoxPro (VFP) is a data-centric, object-orientated, procedural, programming language from Microsoft. The last released version, 9 Service Pack 2, was in 2007. Microsoft has since discontinued the product but it still has active use in business to this day, due to its low cost of deployment and fairly rapid development.

Visual FoxPro is a descendant of (originally FoxBASE), which in turn was based on of the family of file-based databases. In 2007 Microsoft confirmed that there will be no release of VFP 10 or a .NET version of Visual FoxPro.

In 2008 Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. These were developed under the codename Sedna and made available on the site under the shared source license.

The following versions of VFP have been released:

  • 1995 (VFP 3.0)
  • 1996 (VFP 5.0)
  • 1997 (VFP 5.0a)
  • 1998 (VFP 6.0)
  • 2001 (VFP 7.0)
  • 2001 (VFP 7.0 Service Pack 1)
  • 2003 (VFP 8.0)
  • 2003 (VFP 8.0 Service Pack 1)
  • 2004 (VFP 9)
  • 2005 (VFP 9 Service Pack 1)
  • 2007 (VFP 9 Service Pack 2)

Features

  • Database engine, using the format. Supports reading and writing dBase and FoxBASE files. While it retains this backwards-compatibility support, in later versions it included new features that, when used, made the table FoxPro-specific.
  • A built-in query optimizer called Rushmore. The FoxPro implementation of Rushmore made use of existing indexes when an index definition had a matching expression in the issued command.
  • SQL support, in the form of a limited ANSI SQL dialect, although it does have FoxPro extensions here and there.
  • OOP design. FoxPro has reasonable support for classes, class libraries, inheritance, etc.
  • Procedural support. The original FoxBASE was non-OOP and a procedural-oriented language that worked closely with internal data bindings. For backwards compatibility, this was retained.
  • GUI designers for Forms, Reports, and other controls.
  • Access to 3rd party databases was added in later versions. Tables in an outside database (say, MS SQL Server, MySQL, PostgreSQL, Oracle, or some other ODBC-connected database) could be added to a data session and made to appear like local FoxPro tables.

Resources

Please note that FoxPro has long since been discontinued by Microsoft, with the last version being Version 9 SP 2.

1133 questions
29
votes
3 answers

Why doesn't VFP .NET OLEdb provider work in 64 bit Windows?

I wrote a windows service using VB that read some legacy data from Visual Foxpro Databases to be inserted in SQL 2005. The problem is this use to run fine in Windows server 2003 32-Bits, but the client recently moved to Windows 2003 64-Bits and now…
Nelson Marmol
24
votes
6 answers

What's the easiest way to read a FoxPro DBF file from Python?

I've got a bunch of FoxPro (VFP9) DBF files on my Ubuntu system, is there a library to open these in Python? I only need to read them, and would preferably have access to the memo fields too. Update: Thanks @cnu, I used Yusdi Santoso's dbf.py and…
Tom
  • 36,698
  • 31
  • 90
  • 98
13
votes
4 answers

Getting the error "The 'VFPOLEDB.1' provider is not registered on the local machine" even after installing and registering the provider

Alright, so I've got a Windows service that has a FileSystemWatcher that watches an output folder for some Visual FoxPro database files. And it leverages the VFPOLEDB.1 provider to read those files. I cannot go away from this provider because it's…
Mike Perrenoud
  • 63,395
  • 23
  • 143
  • 222
12
votes
3 answers

Visual FoxPro driver for 64 bit Windows 7

I've installed Visual FoxPro driver from this link on my 64 Bit Windows 7 Home Premium OS and tried to register vfpoledb.dll using REGSVR32. I could able to register this dll but when run my application which accesses VFP database is throwing the…
Nagesh
  • 1,216
  • 3
  • 20
  • 44
11
votes
2 answers

How to automate a build for a Visual FoxPro project?

I'm interested in figuring out how to automate a build from Visual FoxPro similar to how we can build .NET projects from the command line using MSBuild. It seems that it is possible to pass command line arguments to VFP.exe which may include the…
jpierson
  • 13,736
  • 10
  • 94
  • 137
10
votes
2 answers

SSIS Package Not Running as 32bit in SQL Server 2012

I have a package that I developed in VS2012 (using the SQL Data Tools component) which collects data from a DBF file using the VFPOLEDB provider, and puts it into a database on a SQL Server 2012 X64 server. The project containing the package has the…
Adam H
  • 183
  • 1
  • 4
  • 16
9
votes
2 answers

How to convert Visual Foxpro database into SQL Server database

One of my clients has a Foxpro database (.DBF file). I need to convert it into a SQL Server 2008 database. Does anyone have any idea how to do this? Kindly give me solution. Thanks in advance....
Rai Micheal
  • 345
  • 2
  • 6
  • 12
9
votes
2 answers

Is it possible to disassemble Visual FoxPro 9.0 exe file?

I have a legacy FoxPro exe application. Source codes are not available (it was written in outsourcing and source codes have been never delivered). There is a request to write exactly the same application in C# and then develop new features.…
Bogdan_Ch
  • 3,146
  • 4
  • 20
  • 37
8
votes
2 answers

TFS MSSCCI Provider with Visual Fox Pro 9 SP2 - cannot update project from project metafile

I have existing project in Visual Fox Pro 9 SP2. I added this project to source control over VFP IDE with MSSCCI provider integrated, then I added files to source control. Everything was ok, but then I update project list and error "cannot update…
polach.o
  • 602
  • 8
  • 15
7
votes
3 answers

How to cast System.Object[*] to System.Object[]

When I Tried to return an Array in VFP9 language COM/DLL to my .NET C# project I receive a System.Object[*] array and I can not cast to System.Object[] (Without asterisk).
Cheva
  • 201
  • 4
  • 10
7
votes
2 answers

C# Read from .DBF files into a datatable

I need to connect to a .dbf file in visual Studio using C# and populate a data table. Any ideas? I can currently view the tables in Visual Fox Pro 9.0 Code I have tried and failed, keep getting External table is not in the expected…
TheCoder
  • 211
  • 1
  • 3
  • 11
6
votes
1 answer

Is it possible to get the client process ID of an application that runs on SQL server?

For my VFP application, i have a program to check currently who is accessing the server (by using sp_who2), also another progam to check who is currently locking which table. But i wish to know which options my users is accessing at the moment. Am…
Andrea.Ko
  • 99
  • 4
  • 12
6
votes
2 answers

How to use VFPOLEDB to get DBF information

I can use GetSchemaTable and GetXMLSchema to get information about field types, sizes etc. from a Foxpro DBF opened with VFPOLEDB but can not get any information pertaining to what indexes are in the tables/CDX. I dont want to use the indexes, just…
CottonHill
  • 73
  • 6
6
votes
5 answers

SQL Join Tables

Table one contains ID|Name 1 Mary 2 John Table two contains ID|Color 1 Red 2 Blue 2 Green 2 Black I want to end up with is ID|Name|Red|Blue|Green|Black 1 Mary Y Y 2 John Y Y Y Thanks for any…
Harley
  • 79
  • 1
  • 4
6
votes
3 answers

How to get the data from fpt and dbf (FoxPro) files?

The files .fpt and .dbf (made in Visual FoxPro 8) have the text (readable for humans) which I need to get or at least to see. But I can't do that. MS excel sees not only the text but also a lot of symbols which make no sense. So my question is how…
user237591
1
2 3
…
75 76