| Pages of Courseware | Hours of hands-on Content | Days of hands-on Content | | 300 pages | 24 hours | 3 days |
|
This courseware begins with a discussion of configuring Visual FoxPro, and a general tour of the Visual FoxPro development environment. You’ll learn to create tables for storing data and views to sort the data, and then learn how to use the Application wizard to start building your first functional application. Proper development is done in the Project Manager, the next topic. Then, you'll learn about Visual FoxPro programming concepts, constants and variables, operators, and constructs. Level 1 also touches on using SQL Server in Visual FoxPro, Y2K issues, and finishes by covering forms, reports and menus.In Level 1 you will learn...
- Plan, create, and modify tables and views, then pull them into a project.
- Use the Application Wizard to build programs quickly.
- Create information from your data with queries and reports.
- Learn programming fundamentals including operators, expressions, program flow, branching and looping, and table navigation.
Prerequisites: To get the most out of Programming Fundamentals of Visual FoxPro 6.0, familiarity with a programming language is helpful, but not required. | Configuring
Visual FoxPro
- The Options Dialog Box
- The VFP CONFIG.FPW file
Visual FoxPro Databases
- Understanding Database Terminology
- Steps to Database Design
- The Database Wizard
- The Visual FoxPro Database Designer
Creating Visual FoxPro Tables
- Using the Table Wizard
- Working with Tables
- Modifying Table Structures with the Table Designer
- Creating Persistent Relationships
The Visual FoxPro Application Wizard
- Introduction to Frameworks
- The Application Wizard
- The Application Builder
The Visual FoxPro Project Manager
- The Project Manager
- Running the Application
Creating Forms with Visual FoxPro
- Using the Form Wizard
- Using the Component Gallery Templates
The Visual FoxPro Language
- Understanding Programming Terminology
- Programming Concepts (How Much Will It Cost?)
- Literals, Constants, and Variables
- Operators
- Variable Scoping
- Program Flow Constructs
- Table/Data Oriented Commands and Functions
- A Couple of Examples
- Dealing with the Year 2000 Problem
Working with Visual FoxPro Forms
- Designing Forms with the Form Designer
- Specifying the Data Environment
- Adding Controls to Your Forms
- Understanding PEM programming
- Data Sessions
- Finding the Owner
Creating Views in the Database
- What Is a View?
- Using the View Wizard
- Expanding the Power of Views
- The View Designer
- Viewing SQL Code
- The Comments Dialog Box
- Creating Parameterized Views
- Queries vs. Views in Visual FoxPro
Creating Reports in Visual FoxPro
- Creating Reports
- Using the Report Wizard
- Using the One-to-Many Report Wizard
- Modifying Reports with the Report Designer
- Creating Reports with the Report Designer
- Printing Reports
Publishing Visual FoxPro Data on the Internet
- Internet Terminology
- What Is HTML?
- Saving As HTML
- The Visual FoxPro Web Publishing Wizard
Appendix Topics Resources for Visual FoxPro Developers
Navigating Visual FoxPro's Interface
Importing Data
Programming Standards and Conventions
|
| Pages of Courseware | Hours of hands-on Content | Days of hands-on Content | | 300 pages | 24 hours | 3 days |
|
Level 2 starts with teaching you how to build applications that others will use, and how you’ll handle more than one person trying to work with the same data. Next you'll explore the Database Container and data dictionaries. Level 2 also talks about object-oriented programming, and why you want to make the time to learn OOP so that your efforts pay off with easier maintenance and better performance in the long run. Testing and debugging are the next big topic covered before moving on to distributing applications.In Level 2 you will learn...
- Leverage your previous programming experience while you begin event-driven programming.
- Use the Visual FoxPro Database Container to enforce business rules.
- Optimize SQL queries with the Rushmore technology in Visual FoxPro.
- Increase productivity as you begin to master object-oriented programming.
- Learn to recognize and solve the design issues involved in multiuser programming
- Learn to use the Visual FoxPro Debugger.
Prerequisites: To get the most out of Programming Visual FoxPro 6.0 Applications, you should have a good understanding of performing basic Visual FoxPro tasks such as creating tables, forms, views, and reports. | The Visual
FoxPro Database Container
- What Is a Data Dictionary?
- Using the Database Container
- Table Options
- The Referential Integrity Builder
- DbGetProp() and DbSetProp()
- The GENDBC Program
The Visual FoxPro View Designer
- Updateable Views
- Top N views
- Outer Joins
- Creating Views Programmatically
- Performance
Using SQL in Visual FoxPro
- Why Use SQL?
- SQL SELECT
- SQL UPDATE
- SQL DELETE
- SQL CREATE
- SQL INSERT
Multi-user Programming
- What’s the Real Challenge in a Multi-user Environment?
- Managing Contention for Resources
- Implicit vs. Explicit Locking
- Buffering Data
- Data Functions in Visual FoxPro
- Transaction Processing
- Resolving Conflicts
Introduction to Object-Oriented Programming
- A Word About OOP
- Understanding Object-Orientation Terminology
- Analysis and Design in an Object-Oriented World
- Using the Visual FoxPro Tools for Class Design
- Instancing Objects Programmatically
- Defining Classes Programmatically
- Viewing Visual Classes as Programs
Advanced Form Design
- Coding Methods in a Reusable Way
- Grids
- Page Frames
- Timers
- OLEBoundControl and OLEControl
The Visual FoxPro Menu Designer
- About Menus
- Creating a Menu Using Quick Menu
- Adding Application-Specific Options
- Customizing a Menu
- Shortcut (Right-Click) Menus
Testing and Debugging Visual FoxPro
Applications
- The Debugger as a Developer’s Tool
- FoxPro Frame vs. Debug Frame
- The Debugger Windows
- Testing Scenarios
- Coverage and Profiling Analysis
Distributing Visual FoxPro Applications
- Developing a Run-Time Version of Your Application
- Building Executables
- Setup Wizard
Appendix Topics
- Resources For Visual FoxPro Developers
- Application and Database Design Considerations
|
| Pages of Courseware | Hours of hands-on Content | Days of hands-on Content | | 100 pages | 16 hours | 2 days |
|
Level 3 features topics that both single professional database developers, and teams of database developers must address. Source code control issues are the first big topic, followed by a discussion of how ActiveX technologies work in Visual FoxPro. Next, you'll learn about ActiveX Data Objects (ADO) and why that is a technology to bring into your applications for the future. You’ll also learn how Visual FoxPro can create sophisticated Internet-ready applications, and how to extend Visual FoxPro’s development environment with builders and hooks into the Project Manager.In Level 3 you will learn...
- Master object-linking and embedding (OLE).
- Create your own programming tools with builders and class libraries.
- Use Visual SourceSafe to maintain version control.
- Explore ActiveX technology in Visual FoxPro.
- Begin building applications that you’ll deploy on the Internet.
Prerequisites: To get the most out of Advanced Visual FoxPro 6.0 Programming Concepts, you should be very familiar with the basics of Visual FoxPro programming and application development. | Multi-Developer
Projects in Visual FoxPro
- Why Multi-Developer Projects Are Different
Understanding Source Control
Putting Projects Under Source Control
Tracking Information About the Source Control Project
Visual FoxPro and the Internet
- Internet Terminology
- What is HTML?
- The Visual FoxPro Internet Wizard
- Accessing the HTML Page With a Browser
ActiveX in Visual FoxPro
- Understanding ActiveX
- ActiveX Automation in Visual FoxPro
- Visual FoxPro as an ActiveX Automation Server
- Creating an ActiveX Automation Server
- OLE Drag-and-Drop
Integrating Visual FoxPro Web Components
- Introduction
- Terminology
- Clients and Servers – How they Work Together
- HTML and Active Server Page Basics
- Authoring Active Server Pages
- Integrating VFP COM Servers and Active Server Pages
Accessing Remote Data Using Visual FoxPro
- Designing Applications in Visual FoxPro That Access Remote Data
Appendix Topics
- Resources for Visual FoxPro Developers
- Calling the Windows API from Visual FoxPro
- Advanced Class Design
- Extending the Development Environment
- Visual FoxPro Active Documents
|
