Visual Fox Pro 6 0 Seminar Presented by

Visual Fox. Pro 6. 0 Seminar Presented by Jim Booth Email: jbooth@jamesbooth. com In cooperation with Rainer Becker and the German Fox. Pro User’s Group (d. FPUG) Visual Fox. Pro™ Seminar

General Issues Related to Development u u Understanding the costs Lowering the costs Ø The Value of Conventions and Standards Ø The Value of Object Oriented Design Ø The Development Cycle Ø Managing Risks Visual Fox. Pro™ Seminar

Database Design u u Characteristics of a “Relational Database Management System” Normalization of Data Design Visual Fox. Pro™ Seminar

Normalization Visual Fox. Pro™ Seminar

Why bother with Normalization u u Reduce the possibility of data inconsistencies Reduce the space required for storing data Reduce possible update and delete anomalies Increase the stability of the data design Visual Fox. Pro™ Seminar

First Normal Form Reduce entities to first normal form (1 NF) by removing repeating or multi-valued attributes to another, child, entity. Visual Fox. Pro™ Seminar

First Customer Pass Customer # Company Name Address Contact 1 Contact 2 Phone 1 Phone 2 Visual Fox. Pro™ Seminar

Removing the Repeating Groups Contacts Customer # Contact # Customer # Name Address Phone Code Company Name Address Contact 1 Contact 2 Phone 1 Phone 2 Phones Customer # Phone Code Area Code Phone Number Visual Fox. Pro™ Seminar

2 nd Normal Form Reduce 1 NF entities to second normal form (2 NF) by removing attributes that are not dependent on the whole primary key. Visual Fox. Pro™ Seminar

Invoice Line Item File Invoice Number Line Number Customer ID Product ID Visual Fox. Pro™ Seminar

Remove the Non. Dependent Fields Line Item Customer ID Invoice Visual Fox. Pro™ Seminar

3 rd Normal Form Reduce 2 NF entities to third normal form (3 NF) by removing attributes that depend on other, non-key attributes (other than alternate keys). Visual Fox. Pro™ Seminar

Purchase Order Number Vendor ID Vendor City Visual Fox. Pro™ Seminar

Remove Fields Depending on Non-key attributes Purchase Order Vendor City Vendor Visual Fox. Pro™ Seminar

Boyce/Codd Normal Form Reduce 3 NF entities to Boyce/Codd normal form (BCNF) by ensuring that they are in 3 NF for any feasible choice of candidate key as primary key. Visual Fox. Pro™ Seminar

An Employee Table Emp. Id Employee Number Clock Number Visual Fox. Pro™ Seminar

An Employee Table Clock Number Employee Number Emp. Id Visual Fox. Pro™ Seminar

An Employee Table Employee Number Clock Number Emp. Id Visual Fox. Pro™ Seminar

Fourth Normal Form Reduce BCNF entities to Fourth normal form (4 NF) by removing any independently multi-valued components of the primary key to two new parent entities. Visual Fox. Pro™ Seminar

Employee - Skill - Objective Table Name Skill - Name Objective - Text Jones accounting more money prestige Jones public speaking more money Jones public speaking prestige Visual Fox. Pro™ Seminar

Fourth Normal Form Employee - Skill Name Skill - Name Employee - Objective Name Objective - Text Visual Fox. Pro™ Seminar

Fifth Normal Form Reduce 4 NF entities to fifth normal form (5 NF) by removing pair-wise cyclic dependencies (appearing within composite primary keys with three or more component attributes) to three or more new parent entities. Visual Fox. Pro™ Seminar

Retail Store Buyers Buying Buyer Vendor Product Mary Sally Suppose Liz Claiborne adds jeans to their list of products. We need to add two updates to our table because both Mary and Sally buy jeans and buy from Liz Claiborne. Jordache Liz Claiborne Visual Fox. Pro™ Seminar Jeans Sneakers Jeans Blouses

Fifth Normal Form Buy-Vend-Prod Buyer Vendor Product Buyer Product Visual Fox. Pro™ Seminar

Denormalization Normalized Name Address Postal Code Denormalized Name Address City Country Postal Code Visual Fox. Pro™ Seminar Postal Code City Country

Want to read more? Relational Database Selected Writings C. J. Date Addison-Wesley Publishing Company ISBN: 0 -201 -14196 -5 Handbook of Relational Database Design Candace C. Fleming and Barbara von Halle Addison-Wesley Publishing Company ISBN: 0 -201 -11434 -8 Visual Fox. Pro™ Seminar

Visual Fox. Pro Database Container u u u u Data dictionary Relationships Field level domains (Field Rule) Table level domains (Table Rule) Referential Integrity Stored Procedures Db. Get. Prop() and Db. Set. Prop() Visual Fox. Pro™ Seminar

View Designer u Updateable Ø The Update Tab in the view designer u Joins Ø Inner Ø Outer Ø Left, u Right, and Full Top N Visual Fox. Pro™ Seminar

Using SQL in the Visual Fox. Pro Language u u Why use SQL at all? The SQL Commands in Visual Fox. Pro Ø SELECT Ø UPDATE Ø DELETE Ø CREATE Ø INSERT INTO Visual Fox. Pro™ Seminar

Designing User Interfaces Visual Fox. Pro™ Seminar

Principle 1 The User Is In Control Visual Fox. Pro™ Seminar

Principle 2 Follow The Object-Action Paradigm Visual Fox. Pro™ Seminar

Principle 3 Be Consistent Visual Fox. Pro™ Seminar

Principle 4 Make Things Self Evident Visual Fox. Pro™ Seminar

Principle 5 Pay Attention To Aesthetics Visual Fox. Pro™ Seminar

Principle 6 Give The User Feedback Visual Fox. Pro™ Seminar

Principle 7 Be Forgiving Visual Fox. Pro™ Seminar

Object Oriented Development Visual Fox. Pro™ Seminar

OO Terminology u u u u Class Object Abstraction Polymorphism Inheritance Messaging Containership Visual Fox. Pro™ Seminar

Analysis and Design in an OO world u The Iterative Approach Ø Inception Ø Elaboration Ø Construction Ø Analysis, Design, Coding, Testing, Implementation, Training, Maintenance/Evolution Ø Transition Visual Fox. Pro™ Seminar

Analysis and Design in an OO world There is a constant looping back in this OO development cycle. New requirements discovered during coding or implementation feed back into the design phase. New functional requirements discovered alter future iterations Visual Fox. Pro™ Seminar

The Visual Fox. Pro Class Designer u u u Save As Class menu option Adding properties and methods to a class Specifying an Include file for a class Creating subclasses Adding controls to the form designer’s toolbar from your Classes Visual Fox. Pro™ Seminar

The Application Framework u u u What is a framework? The overview of the architecture of the framework Strategies for maximizing maintainability Visual Fox. Pro™ Seminar

The Framework In Detail u u u u The Application Manager The form class The startup program Building an application using the framework The form The Menu Enhancing your framework Visual Fox. Pro™ Seminar

Form and Class Design u u Coding methods in a reusable way Using THISFORM, THIS, and the Parent property Using WITH/ENDWITH Using collections to address the contents of a container Visual Fox. Pro™ Seminar

Simple Base Classes Label, Textbox, Edit. Box, Check. Box, Option Button, Option Group Command Button, Command Group Spinner, Image, Line, Shape, Timer Container, and Separator Visual Fox. Pro™ Seminar

Complex Base Classes Combo. Box, List. Box, and Grids Page. Frames Custom, Container, and Control Form, Formset, and Toolbar Visual Fox. Pro™ Seminar

Using Builders Ø The Visual Foxpro Builders Ø Make it easier to setup the complex controls Ø Building your own builders Ø Builder. dbf and Builder. app Ø ASELOBJ() Ø Using the special Builder property of a class Visual Fox. Pro™ Seminar

OLE Base Classes u OLEBound. Control Ø Bound file u to a General Field in a DBF OLEControl Ø Predefined contents at design time. Visual Fox. Pro™ Seminar

Active. X Automation u u u Structure of Active. X Direct Manipulation of an Active. X server Automation of an Object Inside of an OLEControl Visual Fox. Pro™ Seminar

Multi-user Issues u u What is the multi-user problem? Two strategies (Philosophies) Ø Optimistic Ø It is unlikely that there will be a problem when I try to save. Ø Pessimistic Ø It is very likely there will be a problem when I try to save. Visual Fox. Pro™ Seminar

Data Buffering u u u How did we do this before? What’s new and different now? Row versus Table buffering Pessimistic versus Optimistic buffering Choosing the correct buffering mode Visual Fox. Pro™ Seminar

Setting the Buffering Mode Ø Cursor. Set. Prop() (Cursor. Get. Prop()) Ø Using a Cursor’s Buffer. Mode. Override property Visual Fox. Pro™ Seminar

Saving Buffered Edits u u Table. Update() Table. Revert() Get. Fld. State() Get. Next. Modified() Visual Fox. Pro™ Seminar

Transaction Processing The all or none approach BEGIN TRANSACTION, END TRANSACTION, and ROLLBACK Resolving conflicts using CURVAL() and OLDVAL() Visual Fox. Pro™ Seminar

Client/Server - Is It For You? u When does Client/Server make sense? Ø Security Ø Scalability Ø Central Control of Data Visual Fox. Pro™ Seminar

Remote Data Sources u u Setting up data sources under Windows (95, NT, 98) Connections in Visual Fox. Pro Using Remote Views Using SQL Passthrough functions Visual Fox. Pro™ Seminar

Designing Client/Server Applications u User Interface Design Ø No more BROWSE of the customer table u Awareness that your code does not have absolute control over the data updates. Visual Fox. Pro™ Seminar

Using Visual Fox. Pro to Create an Active. X Server u u OLEPublic classes Designing the Server Visual Fox. Pro™ Seminar

Creating Your Own Active. X Automation Servers u In-Process versus Out of process servers Ø DLL u u u versus EXE Compiling the server Registering the server Using the server Visual Fox. Pro™ Seminar

The Visual Fox. Pro Debugger u u The debugger as a developer’s tool Choosing a Fox. Pro frame or the debugger frame Saving and restoring debugger settings Hot Keys in the debugger Visual Fox. Pro™ Seminar

The Debugger Windows Ø Trace Ø Watch Ø Locals Ø Call Stack Ø Output Ø SET DEBUGOUT TO Ø Event Tracking Ø Setting Breakpoints Visual Fox. Pro™ Seminar

Coverage Analysis/ Application profiling u u u SET COVERAGE TO <File. Name> Turning coverage on and off Using the Coverage Profiler Visual Fox. Pro™ Seminar

Using Assertions u u The ASSERT command SET ASSERTS ON/OFF Visual Fox. Pro™ Seminar

Using The Debug. Out Command u u Does not mess up your application screen Does not introduce extra window focus events to your application Visual Fox. Pro™ Seminar

Visual Fox. Pro and the Internet u u u What is HTML? How does the Internet work? The Internet Search Wizard Accessing the search wizard page The Web Publishing Wizard Visual Fox. Pro™ Seminar

Advanced Class Design Concepts u Inheritance Hierarchy Ø The u Containership Hierarchy Ø The u is-a relationship has-a relationship Design Patterns Visual Fox. Pro™ Seminar

Accessing the Windows API from Visual Fox. Pro u u u What is the API? DECLARE command Calling an API function Visual Fox. Pro™ Seminar