This app requires JavaScript! Episodes
ClarionLive
See it. Learn it. Share it.
Episodes
#611
Mike Hanson - Threaded Child Browses - Part 1
MAY 14,2021
[learning] [browse] [queue] [thread]

Series:
#611, #612

0:00 - Start
0:04 - Introduction
0:23 - John shows the first glimpse of the Clarion Class Assistant
0:42 - Mike Starts

Mike takes a window which contains a parent and child browse, changes the child to a List control, and loads the list control from a background thread.
#610
Data Structures In Clarion - Part 3
MAY 07,2021
[learning] [file] [view]

Series:
#594, #600, #610 #620 #628 #621

0:00 - Start
0:04 - Introduction
0:20 - CapeSoft Bug Hunt #1
0:23 - Bruce Starts

FILE and VIEW data structures explored.
See Also: Data Dictionary Webinars #409, #412, #413
#609
Data Internationalization: an experiment! Part 2
APR 30,2021
What is Data Internationalization? It's not what you think! Tune in this week for Part 2 to find out more!
#608
Data Internationalization: an experiment! Part 1
APR 23,2021
What is Data Internationalization? It's not what you think! Tune in this week to find out more!
#607
Everything you wanted to know about recursion, but were afraid to ask!
APR 16,2021
[learning] [recursion]

0:00 - Start
0:07 - Introduction
0:19 - Bruce Starts

Recursion in Clarion. To understand recursion you first have to understand recursion.
#606
Designing An Interface - Using an embedded HTML control in your app!
APR 09,2021
HTML pages are a great way to display information. They're a great way to format information in an attractive manner with not-too-much work. In Clarion, we can embed HTML controls in our apps and take advantage of HTML's display strengths. You can even make links in your HTML that launches other procedures in your app! So how do you do this? Tune in and find out!

NOTE: I posted the App used in the Demo, you will need Chrome Explorer, Codejock Suite Control Wrapper (and Codejock Controls), StringTheory, and UltimateDebug in order to open it/run it. There is a TXA export of the app here as well, so you can just clip the code out of that if so desired!
#605
The One Where Mike Do That Queue-doo That He Do So Well!
APR 02,2021
[learning] [queue]

0:00 - Start
0:05 - Introduction
0:21 - Mike Starts

Queues are a fabulously flexible facility within Clarion, but they can be tricky to use. Mike Hanson will discuss some of their interesting quirks and features. Learn to flex the power of queues, while avoiding potential pitfalls.

Further watching: Bruce Johnson on Data Structures in Clarion, Chapter 2 #600
#604
Carl Barnes' Magical GitHub Mystery Tour!
MAR 26,2021
Carl Barnes has been a prolific contributor to the Clarion Community! Join us today as Carl takes us on a Magical Mystery Tour of his GitHub repository, and reveals the wonders within!
#603
John's Birthday Webinar - Clarion Best Practices!
MAR 19,2021
Join us this week for John's Spectacular Birthday Webinar, with the wide-open topic - Best Practices! Join a remarkable panel of Clarion developers as we pose the question - "what are Clarion best practices"?
#602
Converting NetTalk Web Server to Multi-DLL and Using it in a Multi-Site Host
MAR 12,2021
Single EXE to Multi-DLL featuring NetTalk and a Multi-Site Host

Why multi DLL?

Step by step demonstration of converting a single EXE app into a multi-DLL app.
Common mistakes and how to work around them
Deploying the new multi-DLL app in a NetTalk multi-site host web server.
...and knowing me, there will be more.
#601
NEW! noyantis Wrappers Version 5!
MAR 05,2021
This week, Andy Wilton from noyantis will be demonstrating the all-new version 5 of his popular template/class wrappers for the Codejock controls!

LOTS has changed in this new release, including new support for those with multi-dll solutions! Now, you can do all of your settings in one app, and have those settings apply to ALL procedures in all DLLs! Lots of code optimizations and new features makes this a must-have update!

Tune in to see all the new things you can do in the new noyantis Version 5 wrappers!!
#600
Data Structures In Clarion - Part 2
FEB 26,2021
[learning] [file] [view]

Series:
#594, #600, #610 #620 #628 #621

0:00 - Start
0:04 - Introduction
0:30 - Bruce Starts

Type Casting, Type Conversion, Type Comparison,
References, Pointers,
Complex Types, (Group and Queue),
TYPE attribute

Further watching: Mike Hanson on Queues #605
#599
Templates and Classes and Lists Oh My! Part 10
FEB 19,2021
[learning] [handcoded] [lists]

Series: #566, #568, #571, #574, #578, #582, #586, #596, #598, #599

This week, Mike Hanson continues to continue to continuously continue to continue onward to explore how to write less code for hand-coded lists. All techniques will be considered and applied, included classes, templates, etc.

0:00 - Start
0:02 - Introduction
0:23 - Mike Starts

#598
Templates and Classes and Lists Oh My! Part 9
FEB 12,2021
[learning] [handcoded] [lists]

Series: #566, #568, #571, #574, #578, #582, #586, #596, #598

This week, Mike Hanson continues to continue to continuously continue to continue onward to explore how to write less code for hand-coded lists. All techniques will be considered and applied, included classes, templates, etc.

0:00 - Start
0:02 - Introduction
0:23 - Mike Starts

#597
SetupBuilder Tips & Tricks
FEB 05,2021
[setupbuilder] [mssql] [install]

This week, Andy will be showing us how to use SetupBuilder to install MSSQL, and maybe a few other things as well!

0:00 - Start
0:02 - Introduction
0:20 - Andy Starts

Additional Resources:
From Jane Fleming:

I just wanted to suggest two Complete Beginner resources that somebody might find useful. Both are old. But in Clarion, we’re used to old things.

One is a broad overview video I did 11 years ago intended as part of a series that Friedrich never implemented. It was primarily meant to reduce the fear factor of confronting the IDE. There have been some changes in the IDE since then, but it’s mostly still relevant (if one can tolerate my nasal voice). It consists of 3 short 640x480 MP4 videos:

https://www.beachbunnysoftware.com/SBVideo/sbintro1cc/SBIntro1CC.mp4
https://www.beachbunnysoftware.com/SBVideo/sbintro1cc/SBIntro2CC.mp4
https://www.beachbunnysoftware.com/SBVideo/sbintro1cc/SBIntro3CC.mp4

The second resource (pic below) is a walk through the SB examples with explanations of the differences between compiler directives, script actions, etc.

This can be downloaded within the SB IDE or from the SB website: https://www.setupbuilder.com/products_setupbuilder_dev_download.htm
#596
Templates and Classes and Lists Oh My! Part 8
JAN 29,2021
[learning] [handcoded] [lists]

Series: #566, #568, #571, #574, #578, #582, #586, #596 #598

This week, Mike Hanson continues to continue to continuously continue to continue onward to explore how to write less code for hand-coded lists. All techniques will be considered and applied, included classes, templates, etc.

0:00 - Start
0:02 - Introduction
0:16 - Mike Starts

#595
Backup Code Generator For ISAM Tables
JAN 22,2021
[backup] [isam]

0:00 - Start
0:05 - Introduction
0:16 - Roberto Starts

This week, Robert will be presenting his Dumpload template! The DUMPLOAD template will take all your ISAM tables and EXPORT them as CSV comma delimited files. This template will also IMPORT them and restore your table with previous data. This will give you an additional way of saving data for backup and restore purposes in a TEXT format.

The template is available at Github at https://github.com/RobertArtigas/DumpLoad
#594
Data Structures In Clarion - Part 1
JAN 15,2021
[learning] [file] [view]

Series:
#594, #600, #610 #620 #628 #621

Our first Friday webinar with Zoom Webinars, so a couple technical questions at the beginning, but we get there in the end :)

0:00 - Start
0:08 - Introduction
0:16 - In Memorium: Greg Bailey friend and regular ClarionLive contributor passed away. Tributes by his wife Linnie Bailey, Bijan and Erwin.
0:43 - Bruce Starts

A look at the basic data types available in Clarion.

#593
The Definitive Guide To Writing Templates - Part 5
JAN 08,2021
[learning] [templates]

Series: #545, #548, #558, #573, #593
0:00 - Start
0:01 - Introduction
(The first couple minutes is no-sound - small production mistake - nothing missed.)
0:03 - Sound starts
0:24 - Bruce Starts
0:36 - Template Language
  • %GlobalData, %LocalData
  • %GlobalDataStatement, %LocalDataStatement
  • EXTRACT / REPLACE
  • Built-In Template Procedures
  • LINKNAME, QUOTE, UNQUOTE, TAILNAME, SPLIT, UNSPLIT
  • Declaring Local Variables
  • #LOCALDATA, #AT(%DataSection)
  • #EMBED
  • #SUSPEND, #RESUME, #RELEASE, #QUERY
  • #MODULE templates
  • AbModule.TPW
  • SECTION, ENDSECTION, APPEND
  • #PROCEDURE templates
  • Source Procdure
  • #DEFAULT
Errata: #SECTION _does_ generate immediately, but into a separate file which is APPENDed into the generating file later.
#592
Deep End User Knowledge Management with Clarion EE Part 2
DEC 18,2020
[proposal] [knowledge] [interoperability]

Series: #590, #592

5. Example of how to consume a web service with messaging 100% created with Clarion.
6. Concrete proposal to the Clarion Community to create and consume Clusters of reusable knowledge components and move towards machine and deep learning.
7. Now is the time for an AnyScreen expert to convert a desktop app to a web.

0:00 - Start
0:06 - Introduction
0:27 - Presentation Starts

#591
Official NetTalk 12 Release!
DEC 11,2020
[3rdparty] [CapeSoft] [NetTalk]

Apart from the obvious financial need to have upgrade releases from time to time, the major version numbers are also when I make necessary structural, or wide-ranging changes to NetTalk. And NetTalk 12 is no exception with under-the-hood changes happening in several areas including the SessionData store, Secwin 7 integration, and in website styling.

A few weeks ago an early NetTalk 12 alpha release became available, and several folk have taken the opportunity to give it a whirl, and test some of the structural changes therein. The feedback has been very positive with minimal issues being reported.

Of course not all of my NetTalk 12 feature list will be available on day 1, but as we did with NetTalk 11, development will continue week by week and month by month, with new releases coming out on a regular basis.

First Friday Webinar with talking heads
0:00 - Start
0:05 - Introduction
0:20 - Presentation Starts
#590
Deep End User Knowledge Management with Clarion EE Part 1
DEC 04,2020
[proposal] [knowledge] [interoperability]

Series: #590, #592

1. Knowledge Management in mission critical systems. Layered example in personal medical record.
2. Presentation of the collaborative clusters of the KW Project.
3. Now is the time for someone XML expert with Clarion to show you how to easily build XML files. For example, make an HL7 message.
4. Importance of managing SNOMED-CT and other ontologies with Clarion applications. Here is the key.

Part two (2020/12/18?)

5. Example of how to consume a web service with messaging 100% created with Clarion.
6. Concrete proposal to the Clarion Community to create and consume Clusters of reusable knowledge components and move towards machine and deep learning.
7. Now is the time for an AnyScreen expert to convert a desktop app to a web.

0:00 - Start
0:04 - Introduction
0:22 - Gustavo Starts

#589
Deploying The Chief Data Officer
NOV 20,2020
[enterprise]

What is a Chief Data Officer? "The Chief Data Officer is a Policy, Procedures, Standards and Management Position". So what does all this mean, and why is it important? Tune in Friday and find out!
#588
Analyze.It! Launch!
NOV 13,2020
[3rdparty] [ohnoSoft] [Analyze.It!] [monitoring] [honeycomb]

What is Analyze.It!? Analyze.It! is a template/class add-on that will allow you to collect data from your applications. Simply drop-in the Analyze-It! global template, fill out a few prompts, and you're ready to go!

Data you can collect includes:

* When your application is open and when it's closed
* Details on the computer the app is running on, including Windows version, screen resolution, and more
* Which Procedures are being used, with Procedure tracking
* Automatic GPF reporting
* Did your program just "disappear"? Analyze.It! can report that to you!
* Define custom data you may want to collect (license key, maintenance expiration, etc)
* Add your own "trackers", to collect data on specific application usage. For example, if you've just introduced a new feature, is anyone using it? Add a tracker and find out!

We'll demonstrate the template/class, show it in use with a sample app, and go behind-the-scenes to see what's under the hood!

0:00 - Start
0:03 - Introduction
0:17 - John and Mary Start

#587
How To Make A Custom Runtime Generated NetTalk Web App PDF Report!
NOV 06,2020
[3rdparty] [CapeSoft] [NetTalk] [Reports]

Well, the title says it all, doesn't it? Tune in for another terrific Don Ridley webinar!

0:00 - Start
0:03 - Introduction
0:19 - Don Starts