Clarion Aussie DevCon 2008 Training

This Training package is over 350 Mb in total. It includes a 318 page Training guide (in PDF), over 230 Mb of examples in over 400 folders, Powerpoint slideshows, a 57 page PDF and associated Powerpoint slideshow on Mobile Application Developer Best Practices when designing a user interface, plus lots more.

The graphic above shows a listing of all the different examples. The list below shows a list of all the subjects contained in the 318 page training manual.

All the examples, powerpoint slides, and considerable documentation cover the course material and presentations that were a large part of the week long Aussie DevCon 2008. To see what was covered go to: http://clarion.net.au/index.php?option=com_content&task=view&id=26&Itemid=35

Contents of DevCon 2008 Training Guide:

From C6 to C7 – Transitioning to the New IDE

Start Page.........................................................................................................................14
Menus...............................................................................................................................17
Popup Menus.....................................................................................................................19
Toolbars............................................................................................................................19
Pads..................................................................................................................................20
Pad Docking ......................................................................................................................21
Pad Positioning..................................................................................................................22
Pad Pinning .......................................................................................................................23
Complete Pad Listing ........................................................................................................24
IDE Navigation...................................................................................................................26
General IDE Options .........................................................................................................27

APP and DCT Migration to C7

Conversion........................................................................................................................31
Generation........................................................................................................................32
Build..................................................................................................................................33

Productivity Features: C7 Dictionary Editor/Application Generator

Working in the Dictionary Editor ........................................................................................35
       General Design and IDE Tips .....................................................................................35
       Use the new and even flatter IDE ...............................................................................37
       Sorting and Locating ...................................................................................................37
       Enhanced Conversion support....................................................................................37
Client-Side Triggers...........................................................................................................39
       Adding a trigger...........................................................................................................40
       Trigger Examples........................................................................................................41
Using the Synchronizer .....................................................................................................43
       Getting Started ............................................................................................................43
Data Browsing and Diagramming......................................................................................46
       Getting Started ............................................................................................................46
       Using the Find and Filter Option .................................................................................48
The Dictionary Diagrammer...............................................................................................50
       Creating a Diagram.....................................................................................................50
Working in the Application Generator................................................................................52
ASSERT checking .............................................................................................................52
       What it is .....................................................................................................................52
       Why use it? .................................................................................................................53
       Runtime ASSERT .......................................................................................................53
OOP Embed Tree..............................................................................................................54
The Redirection (RED) file.................................................................................................55
Wizards and Theme Control..............................................................................................57
       Theme Selection .........................................................................................................58
       Behind the Theme.......................................................................................................58
       Theme Maintenance ...................................................................................................59
Version Resource ..............................................................................................................61
XP Manifest .......................................................................................................................63
Rebasing – How to ............................................................................................................65
       The basics of rebasing................................................................................................65

Productivity Features: The new C7 Designers

Control Toolbox .................................................................................................................70
Designer Workspace .........................................................................................................71
Properties Pad...................................................................................................................72
Populating Controls ...........................................................................................................74
Sizing and Moving Controls...............................................................................................75
Alignment Tools.................................................................................................................76
Control Tab Order..............................................................................................................77
Working with Themed Styles.............................................................................................81
Working with Transparent Controls ...................................................................................82
The Menu Editor ................................................................................................................84
The Tab Editor...................................................................................................................86
The List Box Formatter ......................................................................................................88
The Report Designer .........................................................................................................90
Saving your Designer Session ..........................................................................................91

Browse Expertise

Extended Browse Support.................................................................................................93
       Sort Headers ...............................................................................................................93
       Extended Global Overrides.........................................................................................95
List Format Manager - Configuration.................................................................................95
       Format Manager at Runtime .......................................................................................97
       Format Manager in the Extended Options..................................................................99
       Format Manager Development Tips: ........................................................................100
Browse Support Control Templates ................................................................................101
       BrowseNoRecordsButton..........................................................................................101
       SortOrderButton........................................................................................................102
       SortOrderDrop...........................................................................................................102
Additional Sort Orders - Browse......................................................................................103
       Manual Sort Type......................................................................................................103
       Assisted Sort Type....................................................................................................104
Higher Key Component ...................................................................................................105
Filters in the Clarion Chain ..............................................................................................106
Conditional Totaling.........................................................................................................107
Browse Styles..................................................................................................................108
Drop List and Combo Interface........................................................................................112
       General Usage:.........................................................................................................112
       Storing and Displaying the Same Data.....................................................................112
       Displaying Text Data and Storing a Code.................................................................113
Color Rows and Columns................................................................................................115
Table Schematic Description...........................................................................................117
New Edit-In-Place............................................................................................................118
       Global Configuration .................................................................................................118
       Procedure Implementation........................................................................................119
Query Center and Advanced QBE ..................................................................................121
       Using the Advanced QBE List...................................................................................122
       Query Center Operator Translation ..........................................................................124

Form Expertise

Standard Form Behavior .................................................................................................125
       Visual Indicators........................................................................................................126
       Field Navigation ........................................................................................................129
       Override Options (Window).......................................................................................130
Alternative Forms (VCR) .................................................................................................131
       Navigation and Database updates............................................................................132

Look & Feel – Using the UI features of C7

Visual Styles ....................................................................................................................133
Vista Manifest ..................................................................................................................135
Working with Unicode data in C7 ....................................................................................137
       What is Unicode?......................................................................................................137
Unicode and C7...............................................................................................................137

Working with XML classes Template Support and Custom Coding

ToXML/Export to XML .....................................................................................................140
From/Import From XML ...................................................................................................143
View XML.........................................................................................................................144
Simple XML Generation without the Report....................................................................145

Reports in C7 – Template Tools and Techniques

Report from Queues, Memory and Tables ......................................................................147
Print Preview Improvements............................................................................................149
Template Interface for Standard Reports ........................................................................151
       Additional Sort Orders...............................................................................................151
       Break Manager..........................................................................................................154
Vertical and Smooth Progress Bars ................................................................................158

Advanced Report Generation

Common Procedure Prompts..........................................................................................161
HTML..............................................................................................................................162
PDF.................................................................................................................................164
TEXT...............................................................................................................................167
XML ................................................................................................................................168

SQL Application Support

Template Support for SQL...............................................................................................173
       Runtime SQL Properties for Views ...........................................................................174
VIEW support for aggregate functions ............................................................................175
Other SQL Enhancements and General Tips..................................................................177
       Better BLOB support.................................................................................................177
       MATCH and PROP:FILTER......................................................................................177
       MSSQL and Browses................................................................................................179
       SQL and VIEWs........................................................................................................181
       SQL and Case Sensitivity .........................................................................................182

Application Expansion: HTML/Messaging/Graphing/Utilities

HTML Help.......................................................................................................................185
       The Latest Features..................................................................................................186
       Setup and Implementation tips .................................................................................187
       Testing outside of the box.........................................................................................187
Messaging Templates .....................................................................................................188
       Setup and Configuration ...........................................................................................188
       SMTP ........................................................................................................................189
       NNTP ........................................................................................................................190
       Global Address Settings ...........................................................................................191
Example Code .................................................................................................................192
       Document Send Extension .......................................................................................193
       Summary of features.................................................................................................196
Business Graphing ..........................................................................................................197
Design Steps Checklist....................................................................................................197
Example Applications ......................................................................................................202
Extension and Utility templates .......................................................................................203
WriteHLPids Utility...........................................................................................................203
BLOBInControl Extension................................................................................................205

New and Improved Language Support

Project System support ...................................................................................................207
       PRAGMA...................................................................................................................207
Visual Control Support.....................................................................................................208
       LAYOUT/SETLAYOUT .............................................................................................208
       FLAT (LIST) ..............................................................................................................208
       BOXED (TEXT) .........................................................................................................209
       MESSAGE (with copy)..............................................................................................209
Windows Registry Support ..............................................................................................210
       GETREG...................................................................................................................210
       PUTREG ...................................................................................................................210
       DELETEREG ............................................................................................................211
Threading Language Support..........................................................................................212
       INSTANCE................................................................................................................212
       NOTIFY and NOTIFICATION ...................................................................................212
       SUSPEND and RESUME .........................................................................................213
       Launching a thread – Behind the scenes .................................................................214
GROUP Support..............................................................................................................215
       GETGROUP..............................................................................................................215
       HOWMANY...............................................................................................................215
       ISGROUP..................................................................................................................215
More Built-ins...................................................................................................................216
       FIXFORMAT/UNFIXFORMAT ..................................................................................216
       BINDEXPRESSION ..................................................................................................216
       DEBUGHOOK...........................................................................................................216
       DIRECTORY.............................................................................................................217
       STATUS....................................................................................................................217
       QUOTE/UNQUOTE ..................................................................................................218

ABC Library Enhancements

ErrorClass.......................................................................................................................220
FileManager....................................................................................................................221
       Highlights and Changes:...........................................................................................221
       New Properties..........................................................................................................222
       New Methods ............................................................................................................222
RelationManager .............................................................................................................223
       Highlights and Changes............................................................................................223
TransactionManager........................................................................................................224
       Uses ..........................................................................................................................224
       Template Support......................................................................................................224
RTFControlClass .............................................................................................................226
       RTFTextControl.........................................................................................................226
       RTFToolbar ...............................................................................................................227
       RTFStatusBar ...........................................................................................................229
       RTFAction .................................................................................................................229

Clarion Language Utilities

Summary List...................................................................................................................231
Examples........................................................................................................................233

Add-On Drivers: Overview

In-Memory Database Driver (IMDD)................................................................................236
       Overview ...................................................................................................................236
       Uses ..........................................................................................................................237
       Setup.........................................................................................................................237
       Example Code:..........................................................................................................238
Dynamic File Driver (DFD) ..............................................................................................239
       Overview ...................................................................................................................239
       Uses ..........................................................................................................................239
       Setup.........................................................................................................................239
       Example ....................................................................................................................240
IP Driver..........................................................................................................................241
       Overview ...................................................................................................................241
       Uses ..........................................................................................................................241
       Setup.........................................................................................................................241
       Register the Driver and Templates ...........................................................................242
       Dictionary Preparation ..............................................................................................243
       Server Data DLL .......................................................................................................243
       The Client Application ...............................................................................................244
       Deployment Steps.....................................................................................................244
       Setup Notes ..............................................................................................................245
       Example ....................................................................................................................246

Win32 Deployment

Project Options

Getting Started ................................................................................................................249
       The IDE Menu...........................................................................................................249
       Project Pad................................................................................................................251
       Project Options..........................................................................................................251
Project File Terminology..................................................................................................251
Build Targets....................................................................................................................252
Version Targets ...............................................................................................................253
Project Pad ......................................................................................................................254
Project Auto-Detection.....................................................................................................255
Project Options ................................................................................................................256
Output and Errors Pads...................................................................................................258

Multi-DLL Applications

Design Tips ...............................................................................................................261
Procedure Management..................................................................................................262
       Procedures per module.............................................................................................262

Best Practices

The Dictionary..................................................................................................................263
Icons and Buttons............................................................................................................263

Merging Clarion and ABC Template Features

Object Oriented Code in the Clarion chain......................................................................266
Filtered Locators and more..............................................................................................267

Introduction to Clarion.NET

WinForms ........................................................................................................................269
WebForms and WebServices..........................................................................................270
Mobile (Compact Framework) .........................................................................................270

Introduction to WinForms Design

Building a Real-World WinForms Application..................................................................271
       DNET Wizard ............................................................................................................271
       Building your New Clarion.Net Project......................................................................274
       QuickStart .................................................................................................................275
       Application.................................................................................................................275
Anatomy of a Clarion.NET WinForms Application...........................................................276

Introduction to ASP.NET

Building a Real-World WebForms Application ................................................................279
       Templates and Applications......................................................................................279
       QuickStart .................................................................................................................279

Consuming a Public Web Service

How to Do It ..............................................................................................................281

Building a Public Web Service

Going Mobile – Designing a UI model for Mobile Devices

Building a Real-World Mobile Application .......................................................................283
       Templates and Applications......................................................................................283
       QuickStart .................................................................................................................283
       Device Tools .............................................................................................................285

Clarion.Net - Language Enhancements

Properties ........................................................................................................................287
Delegates........................................................................................................................290
       Delegate Evolution....................................................................................................290
Events.............................................................................................................................295
Generics ..........................................................................................................................297

Data Access in Clarion#

Overview.........................................................................................................................299
Data Binding ....................................................................................................................299
       Binding Controls to a FILE........................................................................................299
       Binding Controls to a RECORD................................................................................301
       Binding to a QUEUE .................................................................................................302
DataSets.........................................................................................................................304
       Manually constructed Rows and Tables: ..................................................................304
       Reading Data from XML File into a DataSet:............................................................305
       Reading Data from a Database into a DataSet: .......................................................305

SQLite – A backend for all supported platforms

Example:.........................................................................................................................307

Reports in Clarion.NET

Closing Thoughts

Appendix 1 - Project Macros

Index: