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
5
votes
8 answers

LIMIT in FoxPro

I am attempting to pull ALOT of data from a fox pro database, work with it and insert it into a mysql db. It is too much to do all at once so want to do it in batches of say 10 000 records. What is the equivalent to LIMIT 5, 10 in Fox Pro SQL,…
Matthew Hood
  • 958
  • 3
  • 13
  • 22
5
votes
4 answers

Python dbfpy and FoxPro

I am using an ancient database format here, dbf files. Don't ask why, just know a certain software decided to extend foxpro support because microsoft decided to extend foxpro support. Now, I'm getting the following error on a specific file. I have…
Dalton Conley
  • 1,599
  • 2
  • 28
  • 36
5
votes
1 answer

Where can I download Visual Foxpro? MSDN?

We have a legacy application written in Visual FoxPro I just inherited. We are unable to figure out where to download Visual FoxPro. We have an MSDN subscription which I have been told should get my a license for it as needed but I literally…
benstpierre
  • 32,833
  • 51
  • 177
  • 288
5
votes
1 answer

OleControl instantiated to wrong type - only when using in Reg Free COM?

I have an ActiveX control (created using C#) that I am adding to a form in Visual FoxPro using late binding. It works without problems when I register the control. I want to use reg free COM and created necessary manifest files. Now it load and…
embnut
  • 121
  • 5
5
votes
4 answers

import a DBF file in SQL Server using SQL Script

How can I import a .dbf file into SQL Server using a SQL script? Found answers from this post, but unfortunately none of them work to me :( : Trying to Import FoxPro DBF File to SQL Server and How to import a DBF file in SQL Server When I'm…
Gimo Gilmore
  • 229
  • 9
  • 23
5
votes
6 answers

Why is FoxPro used for POS systems?

I'm looking at upgrading a POS (Point Of Sale) project which is currently built in FoxPro to .net. The planned architecture is quite complex and there is plenty of rationale behind the new technologies chosen. Some of the requirements include the…
Macros
  • 7,099
  • 2
  • 39
  • 61
4
votes
6 answers

Download file (HTTP) with FoxPro

Today I was asked for help with a FoxPro issue, about how to download a file via HTTP. I found two things: one was a paid ActiveX, and the other one requires libcurl. Is there a way to do that without anything additional (VFP 8), something like…
Bozho
  • 588,226
  • 146
  • 1,060
  • 1,140
4
votes
3 answers

Create unique ID's in VFP

I need to create unique record id's in VFP based on mailing information: zip5, address, lastname, firstname. Once created, relational tables will be loaded in SQL server 7 with the unique ID's. Any suggestinos?
user67994
  • 41
  • 1
  • 2
4
votes
4 answers

Transfer Foxpro Database To SQL Server

How to Transfer Foxpro Database To SQL Server ?
rafiei
  • 41
  • 2
4
votes
4 answers

FoxPro fxp files

I know very little about FoxPro but have a project that requires working with a third-party application, based on FoxPro, and a .fxp file. The thrid-party app is a point of sale system and the makers of the software have provided a .fxp file that…
Brian Behm
  • 6,129
  • 1
  • 23
  • 30
4
votes
3 answers

VB.NET - Visual Foxpro OLE DB Problem with Numeric Decimal Column

In Short: I'm using VB.NET 2008 to connect to a Visual Foxpro 6 Database using the vfpoledb.1 driver. When I attempt to fill an OleDbDataAdapter with a dataset table that contains one of the numeric columns, I get the following error message: The…
HK1
  • 11,941
  • 14
  • 64
  • 99
4
votes
2 answers

Reading a FoxPro 2.6 data with Java

I'm trying to read a FoxPro 2.6 database using java to retrieve data from an older FoxPro based application to format the output better. I've tried using JavaDBF and xBaseJ with no success. Is there a common way to connect that would allow me to…
iaremonkey
  • 49
  • 2
  • 7
4
votes
2 answers

Timestamp in DBase7

I'm trying to read DBase 7 timestamp values from .dbf files. From DBase format specification I got the following: 8 bytes - two longs, first for date, second for time. The date is the number of days since 01/01/4713 BC. Time is hours * 3600000L +…
radjiv
  • 43
  • 4
4
votes
2 answers

someone knows how to delete pack foxpro data from oledb driver with c#

this is my code //Probando insercion OleDbConnection conexionFoxPro = new OleDbConnection(); string rutaFoxPro = @"C:\Users\BigMander\Documents\Proyectos de Visual FoxPro\prueba.dbc"; conexionFoxPro.ConnectionString =…
bigmander
  • 133
  • 3
  • 9
4
votes
3 answers

How do I extract the data in a FoxPro memo field using .NET?

I'm writing a C# program to convert a FoxPro database to XML, and everything works except the memo field is blank. Is there something I'm missing to convert that bit? I'm using C# .Net 3.5 SP1, Visual FoxPro 9 SP 1 OLE DB Driver. Connection string…
1
2
3
56 57