This app requires JavaScript! Episodes
ClarionLive
See it. Learn it. Share it.
Episodes
#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

#575
Update.It! Update!
AUG 14,2020
[3rdparty] [ohNosoft] [Update.It!]

Update.It! is a complete management system for your Clarion 3rd party templates. This week, John and Mary will take you through how to setup and use Update.It!, as well as introduce several new features. What are these new features? Tune in to find out! (hint: one of them makes it easy to document what templates you're using where in your applications!).

We'll also look "under the hood" to see how Update.It! was constructed, including different templates and products used throughout the program.

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

#574
Templates and Classes Oh My! Part 4
AUG 07,2020
[learning] [handcoded] [lists]

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

This week, Mike Hanson continues to 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:03 - Introduction
0:13 - Mike Starts

#573
The Definitive Guide To Writing Templates - Part 4
JUL 31,2020
[learning] [templates]

Series: #545, #548, #558, #573 #593

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

  • #UTILITY Templates
  • Predeclared Template Symbols
  • Built-in commands like FORMAT, TODAY, CLOCK, SUB, INSTRING, LEN, CLIP and so on
  • %Application, %DictionaryFile and all dependencies in the help
  • Multi-Valued Symbols
  • %File, %Fields
  • #FIX
  • #PREPARE
  • %Primary, %Secondary, %Otherfiles
  • #REPLACE, #REMOVE
  • #FIND
  • #SELECT
  • %ActiveTemplate, %ActiveTemplateInstance
  • Looping through all tables used by a procedure
  • #CONTEXT
  • Turns out you can iterate #CODE templates
  • %ActiveTemplateType
  • #EXPORT / #IMPORT
#572
Enterprise Data Standards
JUL 24,2020
[enterprise]

0:00 - Start
0:03 - Introduction
0:18 - Mike Starts

Bureaucracies around the world, whether Civilian or Government, and if Government, the Military, all communicate with each other through messages. In WW2, there were the Code Talkers.

Messages are many different types, forms, and have massively different physical constraints. Code Talkers, XML, JSON, CSV, etc. Some are even just binary strings.

Regardless, all messages are really just transmit Information. Further, all messages are structured. There are no truly unstructured messages. That said, if you are able to observe say a half dozen different messages from different forms that contain the exact same information it might be impossible to know that they are the same.

And if some of those messages are US Navy, and others are U.S. Army and other are US Air Force, even if the information content is identical the forms, size and other constraints will likely make all the messages totally different one from another.

So, this presentation is an approach to divide this "problem" into two parts. The first is about THE Knowledge, and the second is about the messages. It is believed that all messages that are intended to contain the same information are able to be commonly understood via the Knowledge from which the message is derived.

It is hoped that if funding can be achieved for this effort, the result will be a strategy for 1) Developing the Knowledge (with an example from the Information Exchange Models from NATO for Command & Control), 2) Developing Messages derived from this Knowledge into different forms, and 3) showing how messages can be examined one to another in terms of their structure and contained "data" that, in the end, shows that the messages are the same. They would be the same because they are derived from the same Knowledge.

What will be posted is 480 minute version of this presentation. The posting will be done later this weekend.
#571
Templates and Classes Oh My! Part 3
JUL 17,2020
[learning] [handcoded] [lists]

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

This week, Mike Hanson continues 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:02 - Introduction
0:19 - Mike Starts

#570
TSPlus Version 14 Review!
JUL 10,2020
[3rdparty] [TSplus]

0:00 - Start
0:03 - Introduction
0:18 - Dries and Bijan Start

This week, Dries and Bijan will be showing TSplus Version 14 Features, including:

* Progressive WebApp
* Virtual Printer
* New License Manager
* Advanced Security
* TSplus Web Portal file upload features
* HTML5 Settings
* Drag and Drop
* Running a Clarion program after the file upload. A joint effort by Dries and Bijan
* Calling a Clarion host app(your app) with the location of the uploaded file.

The documentation and the example apps will be released before the webinar.

The linked TAUpload includes classes that require jFiles2, StringTheory3 and Cryptonite.
#569
Secwin 7 For NetTalk 12 Server
JUL 03,2020
[3rdparty] [CapeSoft] [Secwin] [NetTalk]

Series: #569, #564, #563

Secwin 7 is an all-new imagining of program security and is a massive redesign from Secwin 6. Over 10 000 lines of new code, 4000 lines of new template code, 100 pages of new documentation and a live release webinar showing it all off. What could possibly go wrong with that?

This week.... Secwin 7 For NetTalk 12 Server!

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

#568
Templates and Classes Oh My! Part 2
JUN 26,2020
[learning] [handcoded] [lists]

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

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

0:04 - Introduction
0:22 - Carl's Corner (Do2Class and Libmaker)
0:29 - Mike Starts
#567
Do2Class - Easy change from Routine to Class
JUN 19,2020
[3rdparty] [free] [refactor] [Do2Class]

Advantages of using a local Class as a replacement for Procedure Routines. Do2Class utility makes the required changes for you.

0:00 - Aftermath of the Shave-a-head charity event.
0:09 - Introduction
0:22 - Carl Starts
#566
Templates and Classes and Etc. oh my! - Part 1
JUN 12,2020
[learning [handcoded] [lists]]

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

Mike Hanson is going to explore how to write less code for hand-coded lists. All techniques will be considered and applied, included classes, templates, etc.

0:00 - Mark Riffey works to subvert the rules.
0:11 - Introduction
0:17 - Mike Starts
#565
Active Directory For Dummies!
JUN 05,2020
[windows] [active directory]

This week Jane will be taking us through the mysteries of Window's Active Directory! What is Active Directory? What is it for? How is it used? Tune in for the answers to these questions and more!

0:01 - Introduction
0:13 - Jane Starts
#564
Introducing Secwin 7! Licensing
MAY 29,2020
[3rdparty] [CapeSoft] [Secwin] [Licensing]

Series: #569, #564, #563

Secwin 7 is an all-new imagining of program security and is a massive redesign from Secwin 6. Over 10 000 lines of new code, 4000 lines of new template code, 100 pages of new documentation and a live release webinar showing it all off. What could possibly go wrong with that?

Join us this Friday to find out!

This week.... licensing!

0:02 - Introduction
0:16 - Bruce Starts
#563
Introducing Secwin 7! Access Control on Desktop
MAY 22,2020
[3rdparty] [CapeSoft] [Secwin] [Access Control]

Series: #569, #564, #563

Secwin 7 is an all-new imagining of program security and is a massive redesign from Secwin 6. Over 10 000 lines of new code, 4000 lines of new template code, 100 pages of new documentation and a live release webinar showing it all off. What could possibly go wrong with that?

0:02 - Introduction
0:09 - Bruce Starts
#562
Live Window WYSIWYG Design and PROPs Reflection
MAY 15,2020
[learning] [designer] [preview] [reflection]

This week Carl Barnes will be showing you tips about using the Clarion Window Design. The Preview feature actually writes you a Clarion program using your Window. Sometimes your window causes the preview to fail and shows an error message. It is easy to find the cause of your problems.

A hidden powerful feature is an include file (WindowPreviewer.INC) that lets you insert your own code to affect the preview. Carl will show his WndPreview class that allows you many runtime features in your preview window. You can view the list of controls, unhide or enable controls, inspect their properties (PROP), view LIST Format properties (PROPLIST), resize controls, change LIST Formats (size columns). This class can also add these features to your live program to aid in development.

[Note: If the Previewer always does nothing (no preview, no message) you probably need to install .Net 2.0 and 3.5. They are no longer included with Windows 10. ]
0:00 - Start
0:02 - Introduction
0:23 - Carl Starts

#561
Passing The Data Baton: Using Zapier To Automate Workflows
MAY 08,2020
[zapier] [workflow]

This week, Leroy will be demonstrating how to use Zapier to automate workflows! What is Zapier, you ask? According to the website, "Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work." And there's a free plan! Join us this Friday to learn more!

See "Show Notes" for all the links Leroy referenced!
0:00 - Start
0:08 - Introduction
0:12 - Leroy Starts

Zapier
What is Zapier?
How Zapier Works
Creating a Zap
Using a Zap Template
Terminology
Free Zapier Courses
Youtube Zapier University Playlist
#560
Creating SQL Table Scripts With DCT2SQL
MAY 01,2020
[3rdparty] [free] [dct2sql]

This week, Robert will be presenting his indispensable conversion tool, DCT2SQL!
Here's what he'll be covering:

* Some perspective and why to convert.
* Conversion from TPS to SQL using DCT2SQL.
* A todo list for your conversion.
* Auditing your dictionary.
* What DCT2SQL does and does not.
* How to use the DCT2SQL templates.
* Starting and Evolving your application.
* Some interactive "show and tell".

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

#559
Presenting: The Nearly Complete Version 1.0 Database Migration System
APR 24,2020
[enterprise] [data migration]

Mike Gorman says: I'm going to do a presentation of the near Version 1.0 completed Database Migration System. I can think of only four reasons you might want to attend:

They are:

1. How would I have done that?
2. Oh crap now I have to do that?
3. My clients have my application deployed SQL databases that have to be converted.
4. My clients have a bunch of SQL databases and I want to make more money by selling this to them

0:00 - Start
0:08 - Introduction
0:13 - Mike Starts