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

how to select a file by default when open a folder in vfp 9.0

I want to open a folder, and select a file by default. I do it like this: Declare Long WinExec In kernel32 String @, Integer WinExec("Explorer /select, C:\tt.txt",5) But if the folder has been opened, the file can't be selected by default. How to…
lichaoz
  • 1
  • 1
  • 1
0
votes
2 answers

switching between modeless forms in vfp

I created a modeless form in vfp and set the showwindow properties to '0-in screen'.I placed a button in the form and added 'DO Form Form2' in the click method. Form2 is again a modeless form and the showwindow properties set to '0-in screen'. I run…
wong chung yie
  • 175
  • 1
  • 4
  • 14
0
votes
1 answer

Get values from multiple textboxes

I have in VFP9 a form which on init event dynamically create textbox controls. And I have a button on this form whose function is to get the textbox values in an array. I tried so: ` FOR i=1 TO thisform.Objects.count IF…
Liviu Solcovenco
  • 75
  • 4
  • 13
0
votes
2 answers

brief description about foxpro & sql connection

I started to work in project which is designed using visual foxpro,sql sever & this software is customized means we are bayed from other customer & after that in .prg i'm modifying product & using it. here what i'm facing problem is i'm not getting…
Sharanamma Jekeen
  • 881
  • 1
  • 8
  • 14
0
votes
3 answers

GridControl Refresh

I have a grid control in vfp9 on a form. And I have a button witch deletes (with pack) the current record. After I delete the record the grid doesn't find the resource. It remains only an empty rectangle. I maked something like this: DELETE…
Liviu Solcovenco
  • 75
  • 4
  • 13
0
votes
1 answer

Select data based on date using SQL in C# to retrieve data from VFP db

We are using Abra Suite Software that is using a VFP db. I have a small program in C# that I would like to use to retrieve data from the db and generate a csv file from it. At this point my problem is to get the data based on the range of date that…
Johan G
  • 1,064
  • 3
  • 16
  • 30
0
votes
2 answers

How to update the values of an index column in a free table?

I am supporting a legacy application written in Visual FoxPro 9, and I need some guidance in how to modify the values in an index column of a free table. The table definition is as follows: I want to increment the value of the "lrecordno" column by…
DWRoelands
  • 4,878
  • 4
  • 29
  • 42
0
votes
1 answer

create txt file and display it in internet browser inside vfp form

I'm facing difficulty when creating some kind of a report in vfp. I created a text file, used the ?/?? command to write to the file, then opened it using web browser (OLE Object in vfp form). Set Printer To 'C:\temp\test.txt' set printer on set…
wong chung yie
  • 175
  • 1
  • 4
  • 14
0
votes
2 answers

Why do I get Type Library Not Found when consuming .Net COM Server from FoxPro Client

I have a .Net COM server that has a method that takes a message and a delay as parameters. After the delay, it fires an event sending the message back to the client. It works with .Net and VB6 clients. In order to get the COM event to bind in…
Michael McHenry
  • 137
  • 3
  • 8
0
votes
3 answers

Visual Foxpro modify general field

Firstly, I am not a VFP programmer, so what I'm doing wrong is probably something simple. I'm trying to extract some documents out of general fields in a VFP 9 database. I have a way of doing this by effectively copying and pasting the field into…
Craig Shearer
  • 14,222
  • 19
  • 64
  • 95
0
votes
1 answer

"Cannot find child element" error when calling JBoss Web Service from Visual FoxPro

I'm having this problem. I created a Web Service that runs on top of JBoss 5, using the Seam Framework. The web service has a single method called "login". When I consume the service from a Java client, it works fine, but when I try to consume from…
jpangamarca
  • 713
  • 2
  • 13
  • 33
0
votes
4 answers

Slow printing in vfp using dot matrix printer (LQ-1170)

I know that this is an old topic for vfp programmers. Still, I want to ask for advices that can improve the printing time for my particular case. I recently asked to change a report written in vfp. It use commands such as fputs, etc. The user prints…
wong chung yie
  • 175
  • 1
  • 4
  • 14
0
votes
1 answer

Visual FoxPro 9 dynamic Arrays

I'm trying to get Dynamic Arrays from my ActiveX component trough Visual FoxPro 9, but with no luck. (Edited and Working example) LOCAL objMain, objAdapt #define CrLf CHR(13) + CHR(10) stMsg = "" objMain =…
beic
  • 127
  • 1
  • 2
  • 16
0
votes
1 answer

print line before page changed in vfp reports

I'm creating a report in vfp. The report contains grouping. In the end of each group, i draw a line. Each row in the detail band doesn't contain any line, only at the end of each group. The problem is when the group expand to the next page, in the…
wong chung yie
  • 175
  • 1
  • 4
  • 14
0
votes
1 answer

Acessing Remote SQL Server from Visual FoxPro Application

Dear StackOverflow readers i would like your kind attention towards my one of the problem: I have a Visual Foxpro application, in which i am accessing a remote SQL Server's Stored Procedure. Everything is working fine when I am installing the SQL…
user1297576
  • 1
  • 2
1 2 3
…
81 82