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

Foxpro combobox get selected value?

How to get selected value (two fields binding: name (0) and id(1)), selected index of combobox in foxpro 9.0?
Andiana
  • 1,912
  • 5
  • 37
  • 73
3
votes
5 answers

Access 2013 Linked Tables to DBF files

I have searched here and Google, with no solution so far. The problem is Access 2013 no longer wants to connect to DBF. Each month, I will get 33 DBF files (each with a CDX file) that I have to import into MySQL. The front end for this is Access…
Tom Collins
  • 4,069
  • 2
  • 20
  • 36
3
votes
4 answers

Split Address values into separate columns

I am using a SQL Server 2012 and i have a table with following structures DebCode,DebName,DebBillAdd1,DebBillAdd2,DebBillAdd3 But in my DebBillAdd1 column contains complete address of debtors like below.(DebBillAdd2 and DebBillAdd3 are empty for…
Shafraz Khahir
  • 145
  • 1
  • 2
  • 7
3
votes
5 answers

How easy is it to convert an application from Visual Foxpro 6 to Visual Foxpro 9?

Are there any problems converting a Visual Foxpro 6 application to Visual Foxpro 9; or is this straight forward? Any gotchas that I should watch out for during the process?
James Berry
  • 437
  • 1
  • 8
  • 15
3
votes
2 answers

FoxPro and .NET COM without registration

I use Unmanaged Exports to create a native .dll from .NET .dll so I can access .NET code from Delphi without COM registration. For example I have this .NET assembly: using System; using System.Collections.Generic; using System.Text; using…
Lukas Cenovsky
  • 5,476
  • 2
  • 31
  • 39
3
votes
2 answers

"Parameter is incorrect" error when invoking .NET assembly via COM component

I have a .NET assembly that lives in the GAC. It is registered correctly so that it can be invoked by COM components. This .NET assembly contains a method and an overload to the method: public void Foo(string sValString, out string sOutString,…
Ken
  • 1,830
  • 3
  • 20
  • 32
3
votes
2 answers

Trigger insert not working with insert..select from statement

As per topic, the trigger insert operation is about not working when I insert certain records into mcard_list based on below, SQL Server trigger function: create trigger cmpnupdatemcard on MP.dbo.mcard_list For Insert AS declare @est_no…
koklimabc
  • 53
  • 2
  • 12
3
votes
10 answers

Corp IT Systems direction. Invest in A or B?

This is more of a general question about which direction would be a better investment for the company. Our company's core business application is written in Visual FoxPro and is about 9+ years old. The database is huge 15+ gigs and the core logic…
JBeckton
  • 7,095
  • 13
  • 51
  • 71
3
votes
3 answers

Passing binary data in a string as a COM event parameter

I am trying to get binary data from .NET into FoxPro (a COM compliant language). I have a .NET object that is ComVisible and an event interface with an event with a string parameter. In my example below I have a dummy implementation that returns a…
joshperry
  • 41,167
  • 16
  • 88
  • 103
3
votes
5 answers

How do I set a source control plug in default for Visual Studio 2008?

We recently installed Team Foundation Server 2008 and we are using it for both Visual Studio 2008 code and Visual FoxPro 9 code that we are still migrating to .Net. I had to install the TFS MSSCCI provider to get connectivity from the VFP9 IDE. That…
Paul G
  • 2,722
  • 4
  • 37
  • 54
3
votes
1 answer

how to call a FoxPro stored procedure from T-SQL Script

I'm Working on synchronizing two databases in order to migrate from a legacy FoxPro database to Sql Server. i have a foxpro code that loads and transforms data, and wondering how to call that procedure from SQL server? even in MSDN i have only found…
joe
  • 546
  • 1
  • 6
  • 20
3
votes
3 answers

How do I create a new VFP (OLEDB) table from an existing one using .NET?

We have an application that creates a number of Visual Foxpro (DBF) tables. Each of those tables have a different schema, but they all contain a known date field. I've been asked to create another application (in C#) that will copy the last week's…
dommer
  • 19,610
  • 14
  • 75
  • 137
3
votes
1 answer

Sql Parametrized syntax error with VFP OleDb

I'm trying to make an SQL parametrized update command for a DBF File ( Visual Fox Pro ) I don't know why, but i have a "syntax error" on the "DbCommand.ExecuteNonQuery();". The exception error message is "Syntax Error.". I don't have any additionnal…
Walter Fabio Simoni
  • 5,671
  • 15
  • 55
  • 80
3
votes
4 answers

how to get the full user name?

I have the following code in VBS that works perfectly. it queries AD to get the user full name : Set objSysInfo = CreateObject("ADSystemInfo") strUser = objSysInfo.UserName Set objUser = GetObject("LDAP://" & strUser) strFullName =…
user1327073
  • 1,004
  • 6
  • 14
  • 20
3
votes
4 answers

mySQL 'NOT IN' to vfp equivalent value

I want to know whats VFP9 equivalent to mySQL 'NOT IN'. To give you the exact purpose. I have two tables and I want to display all the numbers in table1 which don't have any occurrence in table2. TABLE1 1 2 3 4 5 6 7 8 9 10 TABLE 2 2 …
Ikong
  • 2,540
  • 4
  • 38
  • 58
1 2 3
…
81 82