COURSE OUTLINE:

Generate Screens

• Create a Screen with the Quick Screen Menu

• Implement Screen Code Snippets
• Understand the role of Setup and Cleanup Snippets
• Use the Form Generator Options
• Be aware of Generator Directives
• Understand how to modify the READ Statement.

Controlling a Screen

• Create a Control Window for Data Navigation

• Understand the SHOW GETS command
• Change the Prompts on a Button
• Refresh a Screen at a lower Read Level
• Use a Browse Window with a Screen.

TOP

Memory Variables

• Define Memory Variable for a Screen

• Use SCATTER and GATHER
• Scatter to an Array
• Understand not to use Regional Variables.

Principles of Screen Design

• Be aware of the full range of Screen Controls

• Understand when to use each type of Control
• Be aware of Screen Types.

TOP

Using the Project Manager

• Use the Project to store Forms

• Build a Project
• Build an Application
• Build a Standalone Executable.

Implement Screen Sets

• Create and Generate Screen Sets

• Use FoxPro Functions to determine the Active Window
• Implement Code Snippets for each Screen in a Set.

TOP

Validation

• Implement Calculated Fields in a Screen

• Understand Field Validation
• Implement Foreign Key Validation for Referential Integrity
• Implement Delete Checks
• Prevent Insert Anomalies
• Force Data Entry of Mandatory Fields.

Screen Specific Menu

• Implement a Screen Specific Menu

• Understand the Menu Builder General Options
• Specify a Pad Name for a Menu Pad
• Release the Menu Pad.

TOP

Context Sensitive Help

• Implement Context Sensitive Help

• Implement Hypertext Links in the Help File
• Implement FoxPro Style Help
• Use the F1 Help Compiler
• Create Windows Style Help.

Window Control

• Use Commands to Resize Windows

• Control and Change the Current Get Object
• Move and Hide Windows.

TOP

Implement Popups

• Understand the DEFINE POPUP Syntax

• Use Popups to prompt for a Record Selection
• Implement a Popup from an Array
• Define a programmed Popup in a Screen
• Implement a Multiple Selection Popup.

Multi User Record Locking

• Understand Record Locking

• Determine a Record Locking Strategy
• Implement a Multi User FoxPro Application.

TOP

Foundation Read

• Understand the limitations of Modal Windows

• Understand the limitation of FoxPro Read Levels
• Understand the principles of the Foundation Read
• Implement a Foundation Read.

Use Arrays to Improve Performance

• Use SQL SELECT Statements to create Arrays

• Use Arrays to Control Record Movement
• Define a Popup using Arrays
• Implement a one-to-many Form.

TOP

PARTICULARS:
 

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