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

Stop VFP from showing dialog boxes when errors occur

I am trying to call an existing VFP 6 application using Jacob which is a COM bridge for Java. val vfp = new Application(new ActiveXComponent("VisualFoxPro.Application").getProperty("Application").toDispatch()) vfp.setVisible(false) try { …
rancidfishbreath
  • 3,944
  • 2
  • 30
  • 44
0
votes
1 answer

how to skip read command in visual fox pro

i am calling an old vfp procedure through DO WITH PARA COMMANDS when the command executes, it displays a form and Waits(Read command) Can i skip this Read, through programing? so that it doesn't wait..
Fayyaz Ali
  • 787
  • 1
  • 8
  • 18
0
votes
1 answer

XBase Language Rounding Weirdness

I have a requirement to take legacy code in an XBase-style language (FoxPro, in this case) and convert it to C#.NET. I want to get identical output from my rewrite, but rounding discrepancies are driving me nuts. I tried…
Buggieboy
  • 4,636
  • 4
  • 55
  • 79
0
votes
1 answer

datepicker in grid using vfp 9.0

my working project is on visual fox-pro 9.0 , so i need design form in that, i am adding grid with following 2 columns, 1st column is text-box control and 2nd column is date-picker control following steps i did it: i created new form added grid…
Sharanamma Jk
  • 137
  • 1
  • 1
  • 8
0
votes
1 answer

Find out the text between two bookmarks in the page header MSWord

I'm looking for a way to find out the text content between two bookmarks placed on the MSWord page header. Suppose two bookmarks are BKM_1 and BKM_2. also the text between two booksmarks is "Test". Local loWordApplication, loDoc,…
ecasper
  • 489
  • 1
  • 10
  • 30
0
votes
2 answers

VFPOLEDB Too large files

I had the assignment of writing several queries to read in some .dbf files. The files are Visual FoxPro files and the big problem here is when I start using joins, because this makes the temporary files extremely big, eventually resulting in errors…
WtFudgE
  • 5,080
  • 7
  • 47
  • 59
0
votes
1 answer

Dynamically set Crystal Report Viewer parameter default value

We are using the Crystal Report viewer (XI I believe but we can upgrade) with a VFP front end. Is there some way to dynamically set the parameter default value at run time? For example, If the user is viewing an invoice and they try to run a…
davids
  • 5,397
  • 12
  • 57
  • 94
0
votes
3 answers

COM Integration

I have a COM object developed in C# which will be consumed in VFP. The object can be loaded by the vfp project on the dev system, by copying the c# dll into the vfp project's main directory, and registering it. I am running the vfp project installed…
Tim
  • 2,731
  • 9
  • 35
  • 72
0
votes
1 answer

Create button events in VFP dynamically

I have a VFP form on which I create a commandbutton dynamically. How can I create a function that will respond to onclick event ? Thanks in advance .
Liviu Solcovenco
  • 75
  • 4
  • 13
0
votes
2 answers

Is there any way to retrieve a schema from a directory of fox pro 9 free tables?

While looking for a way to discover the relationships between fields in Sage ABRA Suite I came an answer that sounded like if you have a free table directory with Visual Fox Pro, you're going to be stuck guessing at what the schema really is: "Is…
leeand00
  • 25,510
  • 39
  • 140
  • 297
0
votes
1 answer

How do I tell what field is being indexed in a free table fox pro directory?

I'm aware that in Fox Pro that when creating an index the indexes are stored in files with the same name as the (.dbf) table and a different extension such as .cdx or .idx. That said how does one programmatically determine what fields of a table…
leeand00
  • 25,510
  • 39
  • 140
  • 297
0
votes
3 answers

Visual Foxpro or VFP 9: Networking the database from a NAS drive

I am very new to VFP9 and need to move all the database files for a 6 user program to a Netgear ReadyNas Duo V2 shared network drive. I have moved the .dbc .dcx .dct .dbf .cdx and .fpt files to the Nas (\Nas-a0-3d-36\Daimler) but I don't know what…
Optorock
  • 19
  • 7
0
votes
2 answers

Vfp Report to jpg

I am trying to export vfp report to jpg using foxypreviewer . Im using this syntax DO foxypreviewer.app LABEL FORM report object type 11 TO ab It is converting all pages in single pdf. I need to save all pages in separately jpg files in single…
chetan
  • 129
  • 1
  • 2
  • 12
0
votes
1 answer

c# dll in vfp, Unable to use

I have written my code in c#, and build dll. When I m creating object in vfp, Im getting error. I am using below code in vfp SET LIBRARY TO bt_print.tlb hh=CREATEOBJECT("bt_print.bt") My c# code is I have checked "Register for COM interop" check…
chetan
  • 129
  • 1
  • 2
  • 12
0
votes
3 answers

Querying Abra Alerts 5.1 Logs?

We are trying to track down a particular ABRA alert which we believe is attached to some sort of custom code which generates msaccess *.snp files. It is believed that we will have a better chance of tracking down the alert by looking at the logs of…
leeand00
  • 25,510
  • 39
  • 140
  • 297
1 2 3
…
81 82