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-oriented, 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 Visual FoxPro 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 third-party databases was added in later versions. Tables in an outside database (say, PostgreSQL, Microsoft  SQL Server, MySQL, Oracle, or some other ODBC or OLEDB - 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.

1228 questions
0
votes
2 answers

Import File Daily

I've got a process that needs to run every single day importing files that are pulled down from an FTP site into the same folder. I've got the entire project down and done except for grabbing the files. Is there any way that I can make FoxPro grab…
Lordv8r
  • 90
  • 1
  • 2
  • 9
0
votes
0 answers

Returning Filename with wildcards in VFP 9

I am trying to locate the full name of a file using a wildcard. The code I have…
Tammy Hartin
  • 69
  • 1
  • 5
0
votes
2 answers

Difference between FoxPro and Visual FoxPro

What is the difference between FoxPro and Visual FoxPro ?
Y.E.P
  • 1,187
  • 6
  • 20
  • 40
0
votes
1 answer

Double quotes with Sql Update

I'm trying to update a database with OleDb and .Net4.5. My updates are working good , even if i use simple quote on a filed, but, when i input a double quote on a field, oledb raise an exception because of this double quote. Here is a an example of…
Walter Fabio Simoni
  • 5,671
  • 15
  • 55
  • 80
0
votes
1 answer

Create class from form object

Using Visual Foxpro 9, I have a complicated grid (currently on a .scx-based form) which I would like to convert into a class (.vcx, not .prg) so I can re-use the grid on other forms. I really don't want to have to create the grid (and its numerous…
Alan Harris-Reid
  • 2,811
  • 8
  • 33
  • 32
0
votes
1 answer

How to use ActiveX DLL in Visual Foxpro 6?

I have an ActiveX COM DLL developed in VB6. How can I use it in Visual Foxpro 6? Please explain with Visual Foxpro 6 code.
Abdul Manaf
  • 61
  • 5
0
votes
2 answers

What causes Error 1309 after editing and saving a class library?

I have a class library in Visual FoxPro (.vcx file). After I edit the code contained within it, and then run my application, I get an Error 1309 '[class library name] is not an object file'. This is after the class has been instantiated, and happens…
user2261248
0
votes
2 answers

Visual Foxpro Data Grid based entry screen forms

I am having three tables first for Parties name, Second for Qualities and third for storing purchase orders. At present I developed order entry form with text boxes. It's difficult to enter order when I am having 10 or 20+ orders from one party in…
Gaurav Gupta
  • 1
  • 1
  • 1
0
votes
1 answer

How to create a scrolling window in VFP 9

In VFP9 I have an application which carries out a pre-defined sequence of operations, then ends. While it runs I need to report progress to the user (such as "reading transaction file", "123 records read", "file abc.txt not found", etc, etc, to the…
finch
  • 549
  • 1
  • 6
  • 18
0
votes
1 answer

Use easyzlib.dll in Visual Foxpro

The easyzlib generates a dll file, and a tried to register it, but a error appears. Then, a create a project in Visual Foxpro for use the ezlib.dll, but other error generates: "Cannot find entry point ezcompress int the DLL." This is the test code: …
user2237533
  • 43
  • 5
0
votes
2 answers

operator/operand type mismatch when update dbf file

i have a program needs to update data in dbf file. but it keeps appear error 'operator/operand type mismatch'. here is sample code : Dim con As OleDbConnection = New OleDbConnection("Provider=vfpoledb;Data Source=C:\folder\paytran.dbf;Collating…
xana
  • 53
  • 2
  • 9
0
votes
0 answers

VFP Macro ability in MS SQL

I have a task, I don't know how to call it... anyway, I need to do a report for multiple people with different setup and I was thinking which of which is the best way to do it. Im using MsSQL to load the data and some stored procedure to extract and…
mirageservo
  • 2,387
  • 4
  • 22
  • 31
0
votes
2 answers

How to process % to negative number in Visual Foxpro

How to do % to negative number in VF? MOD(10,-3) = -2 MOD(-10,3) = 2 MODE(-10,-3) = -1 Why?
liu peng
  • 95
  • 1
  • 2
  • 10
0
votes
1 answer

Visual Foxpro Query for pending quantity

I am having two tables AORDER for Purchase & BORDER for sale. I want to get pending quantity. Sale orders can have more than 1 records against one purchase order. I do not want to show those order having pending quantities 0. I tried this: SELECT ; …
Gaurav Gupta
  • 1
  • 1
  • 1
0
votes
1 answer

vfp9 'THIS' equivalent to vb.net

In VFP9 there is an object reference THIS which provides a reference to the current object in event code or in a class definition. In vb.net there is ME but as i observed it referred to the actual form not the object itself. VFP Code for button1…
Ikong
  • 2,540
  • 4
  • 38
  • 58
1 2 3
…
81 82