This app requires JavaScript! Episodes
ClarionLive
See it. Learn it. Share it.
Episodes
#600
Data Structures In Clarion - Part 2
FEB 26,2021
[learning] [queue] [group]

Series:
#594, #600, #610

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]

Series:
#594, #600, #610

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

#586
Templates and Classes and Lists Oh My! Part 7
OCT 30,2020
[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

#585
Beyond Debugview (Arnold’s Birthday 2019-2020)
OCT 22,2020
[webservice] [debugging] [monitoring] [honeycomb]

We have many tools at our disposal to manage and monitor systems and applications: Logs, Data, Dashboards, Monitoring, Test systems, and more.

While all of these things are helpful, they all create more work. None of us need more work to do.

Debugview (and the OutputDebugString that populates it) is super handy and is the tool of choice for many of us. The problem with Debugview is that you can’t leave it running all day. It sucks up ram and CPU, particularly in high volume situations.

These things hounded me. I have 3 API servers (or 5, depending on the context), 6-7 web servers and while I can RDP into any of them to open Debugview and see what’s going on – I have to KNOW that something is going on.
That points us at notifications – but all they do is make sure that we’re the first one who knows about the problem (usually).

Bottom line, all of these servers and the cognitive load they place on you with their incessant “Hey, I’m doing this”, “Hey, I’m doing that”, and “Hey I’m not feeling too good, better give me some attention” ended up leading me down the path to a solution, which exposed another situation.

The ultimate solution I found, the situation I discovered, and the current state of the solution I created to cure my situation are the real subjects of Arnold’s 2019-2020 double feature birthday webinar. It’s a double feature because it has 31 more slides than the largest slide deck I’ve ever presented from (the previous max was 3).

If you’re spinning plates to keep everything running, this might be a helpful webinar for you.

0:00 - Start
0:05 - Introduction
0:19 - Mark Starts

#584
String Encoding And The Outside World
OCT 16,2020
[learning] [unicode] [chromeexplorer]

Our programs interact with the outside world, and the string encoding we use, and the string encoding they use need to match up. A practical exploration using Chrome Explorer as a working example.
Summary: When things don't work the way you expect, then it means you are not matching how the data is STORED to how it is DISPLAYED.

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

#583
Clarion, Encodings, and Unicode
OCT 09,2020
[learning] [unicode]

For 30 years Clarion programmers have studiously ignored Unicode, and all matters related to string encodings. But Clarion UStrings are coming, and understanding the basics of Unicode, and encodings, is going to matter. This webinar is an entry to a Brave New World." (It's 2020, what could possibly go wrong?)

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

#582
Templates and Classes and Lists Oh My! Part 6
OCT 02,2020
[learning] [handcoded] [lists]

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

This week, Mike Hanson continues to continue to continuously continue to continue 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:04 - Introduction
0:29 - Mike Starts

#581
Json To Clarion Code Conversion - It's like Magic!
SEP 25,2020
[3rdparty] [CapeSoft] [jFiles] [JSON]

It started as some quick code to parse a Json file and create a Clarion queue from it. Bruce started playing with that, and added things, then more things, and even more things... and now it practically writes the whole procedure for you! It even handles things like queues in queues! This week, Bruce will be demonstrating this terrific addition to jFiles!

0:00 - Start
0:05 - Introduction
0:25 - Bruce Starts

#580
Tools and Utilities to make your life easier!
SEP 18,2020
[3rdparty] [non-clarion] [tools]

With Covid-19 changing the way many people work - I'll be reviewing some of the utilities and apps that I use on a daily basis that help me manage mine and my teams development tasks, ranging from simple utilities built into Windows 10, to online admin and planning tools.

  • Clubhouse.io
  • Screencast-o-matic
  • sync.com
  • idrive.com
  • remotepc.com
  • toggl.com
  • realtimesoft.com/ultramon
  • stardock.com

0:00 - Start
0:04 - Introduction
0:21 - Andy Starts

[3rdparty] [free] [DCT2SQL]

This week, Robert will be showing us all the new and exciting features that he's been adding to DCT2SQL! If you need to create SQL scripts from your Clarion Dictionary, this is the tool to use... and it's free!

0:00 - Start
0:01 - Introduction
0:09 - Robert Starts

#578
Templates and Classes Oh My! Part 5
SEP 04,2020
[learning] [handcoded] [lists]

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

This week, Mike Hanson continues to continue to continuously continue 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:19 - Mike Starts

#577
Clarion and .NET Interop!
AUG 28,2020
[learning] [.net]

This week Don Ridley will be presenting Clarion and .NET Interop!

Quick review of enabling COM interop in a .NET DLL project. (Huge THANK YOU to Mark Sarson!!)
How to handle .NET events other than click events.
Why it doesn't work with a Registration Free assembly.
How to make it work.
Handling the events in Clarion.
How to serve GPS data from .NET assembly and what you can do with it.
And more...!

0:00 - Start
0:04 - Introduction (Fireflies.ai)
0:25 - Don Starts

#576
An Overview of the RYB (Run Your Business) Template Set!
AUG 21,2020
[3rdparty] [free] [RYB]

This week, Robert will be demonstrating his RYB (Run Your Business) template collection!

From the description on GitHub:

These are a set of functional templates. Some that I use every day in a number of working projects.

They provide a number of practical developer aids for tracking multi-dll applications across the complete system, apply globally consistent changes to inconsistent cosmetic standards being used over a period of time, to making sure that where you are can be identified to track possible errors.

These are a collection of a lot of odd type items that have been built over a period of time and have made it into some commercial vendors utilities due to their usefulness over time being proven. There are better items than some of these utilities in commercial, free offerings, and out in the wild of the internet. There are some utilities that have made into the skype chats or newsgroups and have been added here. There are some same or similar requests that come up every now and then for some of these items.

When the author can be identified, they are given credit. When no author can be identified, that fact is noted and hopefully someone will come and claim the utility. This is just a place to collect these utilities and functionality and make it available to all for their use and enjoyment.

There a few items that are marked as "experimental" and are not completely worked out or tested in some environments. As much due diligence has been done as possible. The SQL disconnect/reconnect templates came from different sources and work in some specific environments. Be aware, and exercise extreme care. Do not use these SQL templates without extensive testing in a NON-PRODUCTION environment.

0:00 - Start
0:03 - Introduction
0:17 - Robert Starts