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