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
0
votes
1 answer

What should i use to generate and print letters

I'm in the process of building a system that generates printed letters (around 1000 a day) that get sent to our customers and was wondering what are some good tools to use for this. So far i have looked into using Crystal reports and MS Fox pro…
MakkyNZ
  • 2,215
  • 5
  • 33
  • 53
0
votes
1 answer

How do I specify a COM event callback in FoxPro?

It is many years since I did anything with FoxPro, but I have a legacy system that needs work. Okay, I can call a COM-based application such as MapPoint or Excel from FoxPro. I've done that before. However, how do I pass a function or object method…
winwaed
  • 7,645
  • 6
  • 36
  • 81
0
votes
3 answers

Visual FoxPro OLE DB Performance issues looping on DBF file

I have a .DBF file (Well, 6 DBF files with the same structure) that have over a million and a half rows. I also have a C# app that is migrating this data into a SQL database using an API we made. The program starts quickly, being able to process 30…
Thoth2020
  • 21
  • 10
0
votes
1 answer

Foxpro2 in Windows XP VPC "Too many open files"

I am converting an old Foxpro2 DOS app and for reference I have the foxpro app running in a Windows XP VPC. Certain application flows cause a Too many files open error. Any ideas on how to resolve this? I have tried adding FILES=200 in config.sys as…
sreimer
  • 4,913
  • 2
  • 33
  • 43
0
votes
3 answers

Vertical Scrolling Marquee for foxpro

Could anyone could point me to some code/give me ideas on how to create a smooth scrolling vertical marquee for VFP 8 or 9? Any help is appreciated.
nmarmol
  • 813
  • 1
  • 10
  • 10
0
votes
1 answer

How do I use a field(column) of one table variable in another table variable

I came across this situation while migrating our DB from Foxpro to SQL. Below is the sample scenario.. (My original code is little complicated so just tried to create my own example) I created several table variables in my sql server function to get…
rock
  • 585
  • 3
  • 10
  • 26
0
votes
1 answer

Connect to Foxpro with PHP using OLE DB driver

I'm trying to connect to a Foxpro database using the OLE DB Driver I downloaded the driver from http://www.microsoft.com/en-us/download/details.aspx?id=14839 and installed it then create a php script $conn = new COM("ADODB.Connection") or…
mjsolo
  • 195
  • 2
  • 5
  • 18
0
votes
1 answer

Is it possible to have multiple Select Statements inside a CASE Statement in SQL

I am trying to migrate Foxpro DB to SQL Server.. I have a CASE statement in Foxpro which works like this.. CASE *variable* = 1 SELECT * FROM TABLEA INTO CURSOR A CASE *variable* = 2 SELECT * FROM TABLEB INTO CURSOR B CASE *variable* = 3 …
rock
  • 585
  • 3
  • 10
  • 26
0
votes
3 answers

use php & odbc to access foxpro 255 limit on memo fields

I am using PHP to enter data in a visual Foxpro 9 database. My problem is that the ODBC driver is imposing a limit of 255 characters on memo fields. I tried using the following to get round the problem: $sSQL = 'Insert Into detail (IT_DOC,IT_MEMO)…
mjsolo
  • 195
  • 2
  • 5
  • 18
0
votes
1 answer

Foxpro Website Front End-Can't read From Drop Down List

Good morning, I am building a website to act as a Foxpro front end. It's working great except for my one drop down box that has to read a list of names from another Foxpro table. The drop down works fine, but whenever I submit the form the page…
Rich
  • 3
  • 1
0
votes
2 answers

How to use two temporary tables with the same name but different structures

Following is what my logic is supposed to do IF @id = 1 BEGIN SELECT * INTO #abc from table1 END IF @id = 2 BEGIN SELECT * INTO #abc frm table2 END However, when I execute my statements I get the error saying there is already an object named…
rock
  • 585
  • 3
  • 10
  • 26
0
votes
1 answer

VFP 9.0 writing the status window out to a file

Is it possible to write out the status window in VisualFoxPro 9? Not talking about the command window, but the base window of the program that generates text when you use: ? "SomeTextHere" I want to be able to write out all the text to a txt…
Kris Gruttemeyer
  • 872
  • 7
  • 19
0
votes
2 answers

How to Implement Used() in SQL Server

Please asssit on this foxpro to sql server migration requirement.. I have this function USED() in foxpro which determines if a table is open in a work area. Is there any such function in SQL Server that does the same job?
rock
  • 585
  • 3
  • 10
  • 26
0
votes
1 answer

Foxpro program need to understand

I have never used Foxpro before. Can you convert the following Foxpro code into c# so that I can understand the logic. I am mainly interested in the password logic. Also what is spac()? can_p is the .dbf file where username password is stored. but…
jeff
  • 684
  • 1
  • 11
  • 30
0
votes
1 answer

GridControl Navigation

In VFP9 I have a grid control ,witch show the records from a database table. And also I have a command button wherewith I want to navigate from a row to another. I tried with thisform.grid1.ActiveRow = thisform.grid1.ActiveRow +1 ,but this doesn't…