You'll
explore proper handling of MDI windows in multi-threaded programs. Take a look
at the popular "tricks of the trade" when processing windows. Gain an in-depth
understanding of the Clarion language support for creating, reading, and writing
to data files. Take a detailed look into the processing of flat files, ISAM
files, and SQL files. Realize the power of VIEWs for filtering, sorting and
processing data. Understand how to work with Queue's, and the Queue's role in
template generated applications.
Learn
the ins and outs of organizing Reports, reporting on multiple related tables,
handling Group breaks, controlling Page overflow, and how to avoid common
mistakes. The course also includes sample applications with complete source code
for writing reports that display Page of Page(s) as in "Page 1 of
20".
You'll
also explore the different techniques for database maintenance when using ISAM
versus SQL databases, and learn how and when, to harness the power of PROP: SQL
for lightning-fast updating.
Course III — Expert Programming in
Clarion
|
Module |
Topic Outline |
|
The Essentials on defining and processing
Reports
Learn about
organizing Reports and how to avoid common mistakes. You will review
Reporting on multiple related tables. Group breaks, controlling Page
overflow, and details on report control will also be covered.
|
- Explore
the Print Engine, Reports and Views
- Discover
essential language commands
- Improve
the organization of your reports
- Learn to
avoid common mistakes
- Design
label Reports
- Report on
multiple related tables
- Control
page overflow and group breaks
- useful
report control options
- Includes
sample applications with the source code for two Clarion Functions that
allow creating reports that display Page of Page(s) as in "Page 1 of
20". Just import them into your own application.
|
|
An In-depth Look at File and View Processing
You'll
explore in-depth the Clarion language support for creating, reading, and
writing to data files. Take a detailed look into processing flat files,
ISAM files, and SQL-based files. Understand the power of VIEWs for
filtering, sorting and processing data. |
- Dig into
the Clarion language support for creating, reading and writing to data
files
- Explore
FILE structures in the clarion language
- Review the
four essential statements of data processing: ADD, GET, PUT and
DELETE
- Take a
detailed look into processing flat files, ISAM files and SQL-based
files
- Learn how
to best use Key and Index files and the power of VIEWs
- How and
when to use the ReadOnly and Binary attributes in the EXTERNAL NAME for
SQL backends
|
|
Queues: One of the Most Powerful Tools in your Tool
Box
You will
review the data access statements used to manipulate a Queue and gain an
understanding of the queue's role in your template generated applications.
|
- Learn to
properly define and process QUEUE structures
- Discover
how to harness the power of a Queue and the benefits of using
them
- Explore
creating a queue and the right way to empty them
- Dig in to
the data access statements specific to processing a queue
- Understand
the queue's role in your template generated applications
|
|
Database Maintenance
Tasks
Discover the
differences in techniques for Database Maintenance when using ISAM and SQL
databases. Learn how and when to harness the power of PROP: SQL for
lightning-fast updating. |
- Take a
look at several examples of processing mass updates to databases
- Explore in
detail execution control statements and structures
- Compare
differences in techniques for ISAM and SQL databases
- Learn to
harness the power of PROP:SQL
|
|
Essentials on how to access and process a
WINDOW Structure
The course
includes coverage of the different window types; APPLICATION, MDI and SDI,
and discusses proper handling of MDI windows in multithreaded programs.
You'll also look at the popular "tricks of the trade" when processing
windows. |
- Learn the
varied methods of building a WINDOW structure in Clarion
- Discover
the benefits of "Preprocessing" a WINDOW
- Understand
the relationship of OPEN and CLOSE to the ACCEPT statement
- Review
window types; APPLICATION and MDI
- Do's and
Don'ts for handling of MDI windows in multithreaded programs
- Popular
"tricks of the trade" when processing windows
|
|
Event Driven Programming and Property Assignments
You'll
explore Window and Control events, user-defined Events, and setting and
changing control properties at runtime. |
- Understand
the different types of Events, including user defined events
- Explore
Window and Control properties and the different property types
available
- Discover
how to use Property Syntax
- Identify
what properties are supported for a control
- Dig deep
into setting and changing properties at runtime
|
|
Object Oriented Programming
(OOP)
Understand
Clarion's implementation of Object Oriented Programming, when you should
make use of inheritance, and the proper use of PRIVATE and PROTECTED
attributes. |
- Explore Clarion's implementation and language support of
OOP
- Understand the terminology and concepts behind OOP—discover how
these concepts translate into Code
- Know what an object is, what a class is, how objects and classes
are related and how objects communicate by using properties
- Learn Class object qualification syntax, the use of SELF and
Constructors and Destructors
- Understand Class inheritance and how to create a derived
class
- Discover when to make use of PRIVATE and PROTECTED
attributes
- REPLACE and PARENT, binding and the types available
|
|
Construct the Ideal Clarion
Program
In this session you'll take a detailed look at the building blocks
of a typical Clarion program. |
- Explore
the three essential statements: Declaration Executable and
Structured
- Assignment
statements and Logical Expressions
- Common
syntax of all Clarion language statements
- Clarion
Procedures and Routines
- Data
variable types
- Explore
the rich library of Clarion functions
|
