Stack Overflow
Stack Overflow

Questions tagged [foxpro]

FoxPro is a programming language and DBMS originally created by Fox Software, and later sold to Microsoft. It refers specifically to the procedural languages versions, up to 2.6a, released for DOS, and later MS-Windows, Macintosh, and SCO Unix, and not the 3.0 and later releases, called Visual FoxPro, which have object-oriented language features.

FoxPro is a programming language and DBMS released by Fox Software in 1989. It was based on their prior program, FoxBASE, which was a clone of DBase III. Various versions were released for DOS, MS-Windows, Macintosh and SCO Unix. Microsoft purchased Fox Software in 1992, and in 1995 released a new version with object-oriented features, called Visual FoxPro. Many people still refer to the product as "FoxPro."

852 questions
25
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
  • 42,844
  • 35
  • 95
  • 101
19
votes
8 answers

How to understand a database that is already developed?

My question may seem a little weird but I am sure most of you might have gone through this phase. I am currently working on a database migration project (from FoxPro to SQL Server). The DB that is being migrated is vast and I am new on this project.…
rock
  • 585
  • 3
  • 10
  • 26
18
votes
5 answers

How to import a DBF file in SQL Server

How can you import a foxpro DBF file in SQL Server?
Pop Catalin
  • 61,751
  • 23
  • 87
  • 115
12
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
  • 16,435
  • 14
  • 105
  • 149
12
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,328
  • 4
  • 23
  • 39
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
  • 387
  • 2
  • 6
  • 14
8
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
7
votes
4 answers

LINQ with FoxPro?

Is there a reasonable way to access FoxPro databases using LINQ?
mlo
  • 403
  • 5
  • 16
7
votes
11 answers

What is the best way today to maintain clipper 5.3 code?

Are there any successor products on DOS, Windows or Linux?
Aydya
  • 1,867
  • 3
  • 20
  • 22
6
votes
2 answers

How do I manually generate text files for entire project to diff in Visual FoxPro (e.g. .sca, .vca, etc.)

The challenge is that I'm checking my FoxPro code into source control (using Mercurial, but that's not the focus of this question) and would like a quick way to get the FoxPro SCCTEXT output alongside the binary output without using the Tools >…
Kit Roed
  • 5,167
  • 5
  • 30
  • 34
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

SQL query to select a column with expression of non-aggregate value and aggregate function

Tables used: 1) v(date d, name c(25), desc c(50), debit n(7), credit n(7)) name in 'v' refers name in vn table 2) vn(date d, name c(25), type c(25), obal n(7)) name in 'vn' is a primary key and different names are grouped by type ex: names abc,…
Ganapathy
  • 174
  • 1
  • 3
  • 11
5
votes
2 answers

SQL Server Linked Server query running out of memory

I have a DBF file on a network share that I'm trying to select into a SQL Server table. This query: SELECT * FROM OPENQUERY(MyLinkedServer, 'SELECT * FROM DP') ... throws this error: OLE DB provider "MSDASQL" for linked server "MyLinkedServer"…
Laran Evans
  • 1,283
  • 5
  • 15
  • 31
5
votes
2 answers

How To Insert Into DBF File (foxpro)

I have the following code in asp.net: using (OleDbCommand command = dbConnW.CreateCommand()) { string CreateTableK = null; CreateTableK += "Create Table DSKKAR00 (DSK_ID c(10),DSK_KIND N(1),MON_PYM C(3))"; OleDbCommand cmdCreateTable =…
Masoud Zayyani
  • 157
  • 1
  • 2
  • 12
1
2 3
…
56 57