PRESENTS . . . .
THE
SCHOOL
These classes are designed for the filePro application developers who would like to expand their skills to make applications that are more user-friendly and interactive, and to use the tools in filePro that will give the best results for their programming time. You will be provided with programming code that can be used as templates or placed in your library, to add to your own applications.
Programming examples will include features available with 5.0 but many will also be functional under older versions of filePro. Many library routines that will be developed can be added to your own programming environment.
STN introduces its new, expanded training program to better serve the filePro community. This intense course is designed to serve those programmers already maintaining databases, who want to expand their skills with more advanced filePro techniques.
Each student works with an IBM laptop on our new, wireless network with a SCO Unix Server. Each student has a dedicated filePro database with which to create the filePro elements as they are learning them. Student work can be printed as well as displayed on the main teaching screen, to discuss techniques and results obtained.
Prerequisite Skills:
Course 1 for filePro Database Managers, or equivilant experience in filePro which should include Define Files, Screens, and Reports; full understanding of Inquire, Update, Add, and Request Output; and experience in filePro processing doing calculations and assigning dummy variables. Actual filePro programming experience or some actual designs of your own will better prepare you for the topics discussed.
Davideen Price, EOM . . (888) 321-1940 (In Florida), or (800) 321-1969 (In Maryland), or Email Davy
Also, please contact me for your upgrade to filePro Version 5.0 or to the new Version 5.6, fileProODBC, fileProGI, filePro fPcgi, filePro jPedits; or for a copy of the filePro Developer's Reference; or for other available products and services from STN, Inc.
Return To Main filePro Page
Mon - ADVANCED INPUT PROCESSING - Tools,
Tricks & Techniques
For Advanced Developers, Systems Administrators and Programmers who create new databases and make enhancements to existing code for their organizations.
Class Description
This class covers advanced input processing techniques. Chapter 15, Processing Overview, will be reviewed. Emphasis will be on at-when-field processing and other event triggers such as @once, @menu, @ensel, @key, @update. The relation of each to the flow of processing, and effective coding within each label will be taught. The inter-relation with automatic processing will be explained. Advanced browse lookup techniques will be taught. The laboratory project continues with students using these techniques in their database. A workbook with designed projects is provided and used, in addition to the filePro Developer's Reference.
Prerequisites: Full Knowledge of Chapter 15 of the filePro Developer's Reference (Training from previous STN classes is acceptable).
Tue - HEADER / DETAIL PROGRAMMING
For Advanced Developers, Systems Administrators and Programmers who create new databases and make enhancements to existing code for their organizations.
Class Description
Following a quiz and brief review, this class covers the power of the relational database capabilities of filePro. You will learn how to provide, for example, for one or unlimited numbers of items on an invoice; one or unlimited events for an employee in a time & attendance daily work record; one or unlimited items on a purchase order; and similar applications. You will learn how to program pop-up menus to access these lists as if they were part of the header record. A workbook with designed projects is provided and used, in addition to the filePro Developer's Reference.
Prerequisites: Completion of day one, above.
Wed - ADVANCED OUTPUT PROCESSING - Tools,
Tricks & Techniques
For Advanced Developers, Systems Administrators and Programmers who create new databases and make enhancements to existing code for their organizations.
Class Description
Following a quiz and brief review, this class covers advanced output. You will write output programs to manipulate data in your reports. At-label processing will cover @once, @wbrk, @wgt and @done, with tools and techniques to use within each label.
Prerequisites: Completion of day two, above.
Thu - SELECTION / SORT PROCESSING; EXPORTING
DATA; ARCHIVING; ASSOCIATED FIELDS
For Advanced Developers, Systems Administrators and Programmers who create new databases and make enhancements to existing code for their organizations.
Class Description
Following a quiz and brief review, this class covers Sort/selection processing. You will learn new ways to allow operators to answer on-screen questions and avoid using Extended Selection screen and selection sets. laboratory project continues with students using these techniques in their database. You will learn how to extract data from filePro in many formats to suit other programs such as MS Word and Excel; Word Perfect; Access; and many others. You will learn how to easily construct an archive file, and move records between an active and an archive file. As time permits, the class will cover the power of associated fields. A workbook with designed projects is provided and used, in addition to the filePro Developer's Reference.
Prerequisites: Completion of day three, above.