FoxPro Summary summarizes from the basics of FoxPro, functions, commands, arrays, database programming, and right down to publishing the project. It is written to provides helpful FoxPro resources for beginners or anyone who is looking for quick references on FoxPro. This summary is tested against Microsoft Visual FoxPro 6. Some features or functions may differ with other versions. It originated from Mr. David Brettell's FoxPro worksheets (My high-school teacher).

Click here to bookmark this page. Suggestions or comments related to FoxPro, please email to foxpro@jutiphan.com

Click here to view FoxPro Summary forum.

PLEASE NOTE: Do not copy the any FoxPro codes from this webpage, because it may not be working properly as it should be. Choose download option if available.
Many example programs in FoxPro Summary use EmpList.dbf as an example database. Click here to download Emplist.dbf

FoxPro Introduction

• FoxPro Basics, Operators
• Print or show output on the screen 
• Set variables and get user's input

Decision Making & Repeating

• Decision Making (If... Else... Endif statement)
• Decision Making (Do case... Case... Endcase statement) 
• Repeating (Do while... Enddo) statement

Functions

• Date & Time functions
• Text functions
• System functions
• Other functions
• Custom functions
• Using functions for Error-Handling 
• Messagebox() function

Commands

• Wait command
• Set commands (i.e. Set default to, Set cursor, etc.)
• Printing (How to print your work and get the output from the printer)
• Dialogs 
• Quit command

Arrays

• Array Introduction
• Creating arrays and using arrays
• Multi-Dimensional arrays
• Using arrays with databases

Database Introduction

• Database Introduction (See Worksheet1) 
• Common database problems

Database Programming

• Database programming: Main
• BOF() and EOF()
• Open & Close the table
• Add/Insert new record
• Edit the record
• Browse the record
• Search the table
• Sort the table
• Delete the record (Temporary & Permanently)
• Restore the record
• Display the records by using commands 
• Display the records by programming

Publish the project

• Creating a project
• Designing the project & applying the codes (See Worksheet5)
• Creating an executable
• Creating a Setup
• Advices for coursework project

    Comparing the differences between FoxPro, Pascal, and Basic

    Click here to view BMO, my Computer Studies IGCSE Project developed using FoxPro.

Downloads

• Service Packs [External Links]
  • Visual Studio 6 Service Pack 5
  • Visual FoxPro 7 Service Pack 1
  • Visual FoxPro 8 Service Pack 1
• Worksheets
  • FoxPro Worksheet1
  • FoxPro Worksheet5
• Example Database -Emplist.dbf
• Example Programs
  • ColumnView
  • Decision Making
  • Error Checking
  • ListView
  • Search
  • Printing
• Convert numbers into words -InWords Function (Thanks to Jojo G. Dy)

Related FoxPro Articles [External Links]

• Create link to send email using ShellExecute Win32 API
• Transmit data to Serial Port using MSNComm32.ocx
• Receieve data from Serial Port using MSComm32.ocx

Links [External Links]

• http://msdn.microsoft.com/vfoxpro/
  Official Microsoft Visual FoxPro Developer Center website

• http://www.vfug.org/ 
  Visual FoxPro User Group -Free support for FoxPro developers and interested users

• http://www.foxprohistory.org/
  Comprehensive history of FoxPro

• http://fox.wikis.com/
  Open content Web site for Microsoft Visual FoxPro database development.

• http://foxproadvisor.com/doc/14437 
  Differences Between Visual FoxPro and Visual Basic .NET (Part 1)

I hope this summary will be helpful to get started in FoxPro Programming and wish you best of luck!

If you have any suggestions, comments, ideas or if you find any problems, mistakes or would like to share your FoxPro knowledge to make this summary better, then please either post it on the forum, send in a feedback, or email to foxpro@jutiphan.com

Documents & Articles: Main