A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2552) Designing, Planning, and Managing a Windows SharePoint Services Infrastructure - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Course:(2732) Planning Deploying and Managing an Enterprise Project Management Solution - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
Course:(2209) Updating Systems Administrator Skills from Microsoft Windows 2000 to Windows Server 2003 - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2289) Deploying Business Desktops with Microsoft Windows XP and Microsoft Office 2003 - Microsoft Training Courses in London and South West
Course:(2830) Designing Security for Microsoft Networks - Microsoft Training Courses in London and South West
Course:(1582) Building Web Applications Using Microsoft Visual InterDev 6 - Microsoft Training Courses in London and South West
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1008) Developer Reskilling: Visual FoxPro to Visual Basic - Microsoft Training Courses in London and South West
Course:(2073) Programming a Microsoft SQL Server 2000 Database - Microsoft Training Courses in London and South West
Course:(F1002) Visual FoxPro 6.0 Enterprise - Microsoft Training Courses in London and South West
Course:(5060) Implementing Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Course:(2030) Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services - Microsoft Training Courses in London and South West
Course:(2934) Deploying and Managing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 - Microsoft Training Courses in London and South West
Course:(50046) Introduction to Development Using Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(2731) Deploying and Managing Microsoft Identity Integration Server (MIIS) 2003 - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(F1012) Visual FoxPro 7.0 Programming - Microsoft Training Courses in London and South West
Course:(5115) Installing and Configuring the Windows Vista Operating System - Microsoft Training Courses in London and South West
Course:(50354) Microsoft SharePoint 2010 SharePoint Designer - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(2278) Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure - Microsoft Training Courses in London and South West
Course:(2553) Designing, Planning, and Managing a SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(2723) Microsoft SQL Server 2000 for Experienced Database Professionals - Microsoft Training Courses in London and South West
Course:(5105) Deploying Microsoft Windows Vista Business Desktops - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(2591) Implementing Replication Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(2274) Managing a Microsoft Windows Server 2003 Environment - Microsoft Training Courses in London and South West
Course:(1131) SQL Server 7.0 Upgrade and Migration - Microsoft Training Courses in London and South West
Course:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses in London and South West
Course:(2093) Implementing Business Logic with MDX in Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2827) Deploying Microsoft Windows Rights Management Services - Microsoft Training Courses in London and South West
Course:(2071) Querying Microsoft SQL Server 2000 with Transact-SQL. - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5179) Implementing and Maintaining Telephony Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Course:(2074) Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(5061) Implementing Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(50051) Architecting Microsoft Office SharePoint Server 2007 Portals and Collaboration Solutions - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5928) Managing Projects Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Course:(50050) Architecting Documents and Records Management Solutions with Microsoft Office SharePoint 2007 - Microsoft Training Courses in London and South West
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Course:(1634) Accelerated Training for Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Course:(5929) Managing Projects and Programs Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Course:(2297) Planning Implementing Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCSE on Windows 2000 - Microsoft Training Courses in London and South West
Course:(5119) Supporting Windows Vista Computers with Desktop Images and Application Packages - Microsoft Training Courses in London and South West
Course:(2207) Updating Systems Administrator and Systems Engineer Skills from Microsoft Windows 2000 to Windows Server 2003 - Microsoft Training Courses in London and South West
Application Architecture Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Course:(50049) Architecting Web Content Management Solutions with Microsoft Office SharePoint 2007 - Microsoft Training Courses in London and South West
Course:(1609) Designing Data Services and Data Models - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2014) Customizing Microsoft Office SharePoint Portal Server 2003 - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Course:(5116) Configuring Windows Vista Mobile Computing and Applications - Microsoft Training Courses in London and South West
Course:(2151) Microsoft Windows 2000 Network and Operating System Essentials - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2092) Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services - Microsoft Training Courses in London and South West
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - Microsoft Training Courses in London and South West
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(6064) Planning, Implementing, and Managing Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Course:(6292) Installing and Configuring Windows 7 Client - Microsoft Training Courses in London and South West
Course:(6438) Implementing and Administering Windows SharePoint Services 3.0 in Windows Server 2008 - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(50219) Introduction to Microsoft Windows 7 for Developers - Microsoft Training Courses in London and South West
Course:(2210) Updating Systems Engineer Skills from Microsoft Windows 2000 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(6291) Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta - Microsoft Training Courses in London and South West
Course:(5058) Deploying Microsoft Office 2007 Professional Plus - Microsoft Training Courses in London and South West
Course:(3370) First Look: Getting Started with Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(6067) Developing Native Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(2554) Designing, Planning, and Managing a Windows SharePoint Services and SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(2299) Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCSA on Windows 2000 - Microsoft Training Courses in London and South West
Course:(50429) Microsoft SharePoint 2010 Business Intelligence - Microsoft Training Courses in London and South West
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2013) Optimizing Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Course:(2810) Fundamentals of Network Security - Microsoft Training Courses in London and South West
Course:(6066) Developing Managed Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(1140) Microsoft SQL Server 7.0 Overview - Microsoft Training Courses in London and South West
Course:(8036) Designing IT Platform Collaborative Applications with Microsoft SharePoint 2003 Workshop - Microsoft Training Courses in London and South West
Course:(1017) Developing Web Applications with Visual Interdev - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Course:(2276) Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2208) Updating Support Skills from Windows NT 4.0 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(2439) Scripting Microsoft Windows Management Instrumentation - Microsoft Training Courses in London and South West
Course:(2088) Designing a Highly Available Web Infrastructure (IIS) - Microsoft Training Courses in London and South West
Course:(2277) Implementing Managing and Maintaining a Microsoft Windows Server 2003 Network Infrastructure: Network Services - Microsoft Training Courses in London and South West
Course:(5178) Implementing and Maintaining Audio/Visual Conferencing and Web Conferencing Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(2264) Exam Preparation for the MCDST Certification - Microsoft Training Courses in London and South West
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(3374) First Look: First Look: Getting Started with Microsoft Office 2007 SharePoint Server Hands-On Lab - Microsoft Training Courses in London and South West
Systems Management Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2273) Managing and Maintaining a Microsoft Windows Server 2003 Environment - Microsoft Training Courses in London and South West
Course:(2823) Implementing and Administering Security in a Microsoft Windows Server 2003 Network - Microsoft Training Courses in London and South West
Course:(F1016) Upgrading to Visual FoxPro 8.0 from Visual FoxPro 7.0 - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10175) Microsoft SharePoint 2010, Application Development - Microsoft Training Courses in London and South West
Course:(F1017) Visual FoxPro 8.0 Intensive - Microsoft Training Courses in London and South West
Course:(F1014) Visual FoxPro 7.0 Enterprise - Microsoft Training Courses in London and South West
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(2955) First Look: Microsoft BizTalk Server 2006 for IT Professionals - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Course:(2275) Maintaining a Microsoft Windows Server 2003 Environment - Microsoft Training Courses in London and South West
Course:(F1015) Visual FoxPro 7.0 Upgrade - Microsoft Training Courses in London and South West
Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2279) Planning Implementing and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure - Microsoft Training Courses in London and South West
Course:(2300) Developing Security-Enhanced Web Applications - Microsoft Training Courses in London and South West
Course:(2016) Bringing Data into Desktop Programs using the Microsoft Office 2003 Editions Research and Reference Technologies - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(6290) First Look: Windows 7 Beta for IT Professionals - Hands-on Lab - Microsoft Training Courses in London and South West
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Mobile Internet Toolkit Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(2091) Building XML-Enabled Applications Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(4001) Team Collaboration Using Microsoft Windows SharePoint Services - Microsoft Training Courses in London and South West
Course:(50352) Microsoft SharePoint 2010 Overview for End Users - Microsoft Training Courses in London and South West
Course:(50218) Microsoft Windows 7 Training for Developers - Microsoft Training Courses in London and South West
Course:(5927) Managing Projects Using Microsoft Office Project 2007 - Microsoft Training Courses in London and South West
Course:(10174) Configuring and Managing Microsoft SharePoint 2010 - Microsoft Training Courses in London and South West
Course:(5177) Implementing and Maintaining Instant Messaging Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - Microsoft Training Courses in London and South West
NET Framework Development Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1001) Visual FoxPro 6.0 Intensive - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5117) Installing, Configuring, Troubleshooting, and Maintaining Windows Vista - Microsoft Training Courses in London and South West
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates


Exclusive
Visual FoxPro

Visual FoxPro 7.0 Programming
(Microsoft Training Course: F1012) - 2 days - £1200 exc VAT

 FebMarAprMayJunJulAugSepOctNovDecJan
London09
Ask a Question ?Print 2 Page PDF


> Target Audience
The course is designed for individuals who are new to Visual FoxPro and require an introduction to programming techniques. Delegates may be users of existing databases who need to code small modules. Those intending to develop large Visual FoxPro applications should use this course as preparation for Course F1013 Visual FoxPro 7 Intensive.
> Course outline
  1. xBase Overview
  2. Introduction to Data Handling
  3. Configure the VFP Environment
  4. Datafile Basics in Code
  5. View the Records in a Table
  6. Navigating a Table
  7. Datafile Analysis
  8. Using Variables
  9. Datafile Management Commands
  10. Elementary Programming Commands
  11. Create and Use Indexes
  12. Import and Export Data
  13. Output Reports
  14. Elementary Programming Techniques
  15. FoxPro Functions
  16. FoxPro Expressions
  17. The BROWSE Command
  18. Structured Programming
  19. Procedures and Sub-routines
  20. User Defined Functions
  21. Using The Debug Tools
  22. Error Handling
  23. SQL Commands
  24. Use FoxDoc
Module 1: xBase Overview
  • Use the Command Window
  • Use the Program Editor
  • Understand the Program Menu
  • Use & customize the Toolbar
  • Use the command window to execute commands & functions
top
Module 2: Introduction to Data Handling
  • Use commands to open databases and tables, set index orders and relations
  • Know how to LOCATE records
  • Set a Filter on a Table
  • Understand xBASE Syntax
  • Understand the Scope, For and While clauses
  • Perform Calculations on Table Data
top
Module 3: Configure the VFP Environment
  • Change the file and directory locations
  • Change the Regional and Data options
  • Dock and undock windows
top
Module 4: Datafile Basics in Code
  • Datafile Management - Work Areas
  • Open Tables in work areas
  • Select a particular Table Establish Relational links between tables
  • Use and test a One to Many relation
  • Use and test a Many to One relation
top
Module 5: View the Records in a Table
  • Use the Browse option to view and modify data
  • Modify the Browse layout to see selected fields
  • Use both Browse and Change displays
top
Module 6: Navigating a Table
  • Understand the record focus
  • Move to the next, previous, top, bottom or specified record
  • Search for one or more records matching specific criteria
top
Module 7: Datafile Analysis
  • Count the number of records in a table that match specific criteria
  • Summate or average values in tables
  • Carry out more calculations on tables, including finding maximum and minimum values
top
Module 8: Using Variables
  • Understand the data types of variables
  • Understand variable naming conventions
  • Assign values to variables & display variables
  • Use the EVALUATE function
  • Use macro substitution and referencing in command lines
  • Assign Memory Variables with the Store command
  • Use and know the different data types
  • Use variables in commands
  • Display FoxPro memory
  • Save sets of memory variables to a file using optional wildcards and clauses
  • Restore variables from a file
top
Module 9: Datafile Management Commands
  • Use the command line to manipulate databases
  • Use commands to open and close tables
  • Write a program to set up the environment, open tables, set the index order and set relationships
top
Module 10: Elementary Programming Commands
  • The xBASE Command Language
  • System Configuration Commands
  • Setting the environment
  • Understand command syntax
  • Use the help screen
  • Use the command reference manual
top
Module 11: Create and Use Indexes
  • Create simple ascending and descending indexes by modifying the record structure
  • Apply indexes to change the record order
  • Create compound indexes
  • Find and retrieve records using the index
top
Module 12: Import and Export Data
  • Copy records to new tables
  • Copy records to different file formats
  • Limit the records & fields selected for import
  • Add records from other tables
  • Add records from different file formats
  • Limit the records & fields selected for export
top
Module 13: Output Reports
  • Preview report output
  • Send reports to a printer
  • Set printer options
top
Module 14: Elementary Programming Techniques
  • Be Able to Create and Run Programs
  • Add Comments to a Program
  • Provide developer information
  • Beautify Code
  • Use Intellisense
top
Module 15: FoxPro Functions
  • Use FoxPro Functions within FoxPro commands
  • Understand the additional scope and functionality available by using functions in commands
top
Module 16: FoxPro Expressions
  • Use the FoxPro expression builder to store complex expressions into variables
  • Use the EVALUATE function to make program commands more flexible
  • Use macro substitution as the ultimate tool
  • Use referencing to enable expressions to be used where names are expected in the command syntax
top
Module 17: The BROWSE Command
  • Use the browse command and key words to protect tables
  • Use key words to store browse formats so that they can be reused
  • Use field clauses to protect and validate fields
  • Include fields from other related tables
  • Use expressions to calculate or derive new columns in the Browse
top
Module 18: Structured Programming
  • Use essential Programming Standards
  • Write programs using conditional and code structures (IF..ENDIF DO CASE..ENDCASE)
  • Write programs using iterative code structures (DO WHILE..ENDDO FOR..ENDFOR SCAN..ENDSCAN).
  • Use the Immediate IF function
  • Understand compile time constants
top
Module 19: Procedures and Sub-routines
  • Understand the compile option
  • Store and run programs as .PRG text files
  • Store and run sub-routines using different options
  • Call subroutines and control program flow
  • Assign Public,Local and Private Memory Variables
  • Be aware of modular coding techniques
  • Use the Document window
top
Module 20: User Defined Functions
  • Write User Defined Functions (UDFs)
  • Use UDFs in FoxPro commands to extend FoxPro’s functionality
  • Change the parameter passing method for UDFs and procedures
top
Module 21: Using The Debug Tools
  • Use the Trace window to follow program execution and suspend programs
  • Use the Watch window to set breakpoints and amend variables
  • Use the Debugout window
  • Use the Locals window to display and amend local variables
  • Use the Call Stack window to view currently executing programs
  • Use Event Tracking and Coverage Logging
top
Module 22: Error Handling
  • Trap an error
  • Display Error information
  • Collect environment and status information
  • Use Local and Global error traps
top
Module 23: SQL Commands
  • Use the SELECT command
  • Understand the additional functionality not supported by the Query designer.
  • Use the CREATE TABLE command
  • Use the ALTER TABLE command
  • Use the INSERT INTO command
  • Use the SQL DELETE and UPDATE commands
top
Module 24: Use FoxDoc
  • Create formatted programs
  • Document program hierarchies, variable cross references etc
top
> Pre-Requisites
Before attending this course, students should have the following pre-requisites:
  • A familiarity with Windows and database concepts.
> Purpose
The course introduces the key features and functionality of Visual FoxPro code with an emphasis on the rapid implementation of a database application. This course uses code rather than the Visual Design Tools to give a thorough preparation for Course F1013. During the course the delegate will use a broad range of VFP commands and functions, with a view to writing efficient reusable code. Course contents may alter slightly from those stated.
> EXAMS
There are no exams directly associated with this course