COURSE OUTLINE:

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

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

Configure the VFP Environment

• Change the file and directory locations

• Change the Regional and Data options

• Dock and undock windows

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

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

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

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

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

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

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

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

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

Output Reports

• Preview report output

• Send reports to a printer

• Set printer options

Elementary Programming Techniques

• Be Able to Create and Run Programs

• Add Comments to a Program

• Provide developer information

• Beautify Code

• Use Intellisense

TOP

FoxPro Functions

• Use FoxPro Functions within FoxPro commands

• Understand the additional scope and functionality available by using functions in commands

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

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

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

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

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

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

Error Handling

• Trap an error

• Display Error information

• Collect environment and status information

• Use Local and Global error traps

TOP

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

Use FoxDoc

• Create formatted programs

• Document program hierarchies, variable cross references etc

TOP

PARTICULARS:
 

Cost:	£660 ( € 1056) excluding VAT
Platform:	Windows 2000
Numbers:	Maximum of 6 people on each course at F1’s training facilities in London, Bath and Manchester