III — Expert Programming In Clarion
course covers the Clarion language end-to-end: from Program
layout to Windows, Files and Views; and Queues to Reports,
OOP and Database maintenance processes. Course III digs into
the development techniques required to write your own custom
Procedures, Routines or Programs. Whether you are writing
code into an Embed point, or creating a specialized Procedure
for your application the information in this course will guide
you in building solid applications.
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.
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".
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.
Essentials on defining and processing Reports
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.
the Print Engine, Reports and Views
essential language commands
the organization of your reports
to avoid common mistakes
on multiple related tables
page overflow and group breaks
report control options
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.
In-depth Look at File and View Processing
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.
into the Clarion language support for creating, reading
and writing to data files
FILE structures in the clarion language
the four essential statements of data processing:
ADD, GET, PUT and DELETE
a detailed look into processing flat files, ISAM files
and SQL-based files
how to best use Key and Index files and the power
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
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.
to properly define and process QUEUE structures
how to harness the power of a Queue and the benefits
of using them
creating a queue and the right way to empty them
in to the data access statements specific to processing
the queue's role in your template generated applications
Database Maintenance Tasks
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
a look at several examples of processing mass updates
in detail execution control statements and structures
differences in techniques for ISAM and SQL databases
to harness the power of PROP:SQL
on how to access and process a WINDOW Structure
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
the varied methods of building a WINDOW structure
the benefits of "Preprocessing" a WINDOW
the relationship of OPEN and CLOSE to the ACCEPT statement
window types; APPLICATION and MDI
and Don'ts for handling of MDI windows in multithreaded
- Popular "tricks of the trade" when processing windows
Event Driven Programming and Property Assignments
explore Window and Control events, user-defined Events,
and setting and changing control properties at runtime.
the different types of Events, including user defined
Window and Control properties and the different property
how to use Property Syntax
what properties are supported for a control
deep into setting and changing properties at runtime
Oriented Programming (OOP)
Clarion's implementation of Object Oriented Programming,
when you should make use of inheritance, and the proper
use of PRIVATE and PROTECTED attributes.
Clarion's implementation and language support of OOP
the terminology and concepts behind OOP—discover
how these concepts translate into Code
what an object is, what a class is, how objects and
classes are related and how objects communicate by
Class object qualification syntax, the use of SELF
and Constructors and Destructors
Class inheritance and how to create a derived class
when to make use of PRIVATE and PROTECTED attributes
REPLACE and PARENT, binding and the types available
Construct the Ideal Clarion Program
this session you'll take a detailed look at the building
blocks of a typical Clarion program.
the three essential statements: Declaration Executable
- Assignment statements and Logical Expressions
syntax of all Clarion language statements
Procedures and Routines
- Data variable types
the rich library of Clarion functions