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

#558
The Definitive Guide To Writing Templates - Part 3
APR 17,2020
[learning] [templates]

In Webinar 545, Bruce began a series on how to write Templates. This is part 3 of that series! Series: #545, #548, #558, #573 #593

0:00 - Start
0:01 - Introduction
0:19 - Bruce Starts
  • Creating a Control template
  • Converting Windows Controls into the Control template
  • %ControlInstance %ActiveTemplateInstance
  • %ControlOriginal
  • %ActiveTemplate
  • REQ
  • Finding the variable of a parent template
  • Global Extensions
  • Global setting for turning off a whole template
  • Generating code into every procedure
  • Local Extensions added automatically by Global Extensions
  • #RESTRICT / #ACCEPT / #REJECT
#557
Winning the Game with Clarion!
APR 10,2020
When Mike plays games on his phone, he tends toward puzzles and tower defense games. He was stymied by one, so he decided to use Clarion to solve it. He'll show how he used classes, unit testing, and run-time control creation to beat the game.
#556
Update.It! product launch, overview and behind-the-scenes!
APR 03,2020
Finally! It's launching! Probably!

Update.It! is a subscription application that keeps track of all of your third party products, automatically downloads new versions, and makes it quick and easy to install them! We'll go through setup and the many features of Update.It!, plus take a behind-the-scenes look at the many components that make the entire system work (including the subscription module!).
#555
New! Calendar Control Template Wrapper Update!
MAR 27,2020
This Friday Andy will join us to demonstrate a brand new release of his spectacular Calendar template wrapper for the Codejock Calendar control! Oh yes, you'll want to see this!
#554
Creating a Multi-App Solution
MAR 20,2020
This Friday Mike will revisit how to configure a multi-APP solution so that a DLL is shared by the other APPs. While he's at it, he'll discuss ABC Families, and how to make use of them.
#553
Introducing Chrome Explorer!
MAR 13,2020
[3rdparty] [capesoft] [chrome explorer]

For years, CapeSoft's File Explorer has allowed us to embed Microsoft's Internet Explorer to embed HTML in your Clarion app. That all changes with the new Chrome Explorer!

Chrome Explorer is based on Chromium, an open-source browser project that aims to build a safer, faster, and more stable way for all Internet users to experience the web! The new Microsoft Edge browser is based on Chromium, so this will bring us all right up to date with our HTML displays!

See also: #615 for a follow up on the ACE editor and calling JavaScript.

#552
Clarion Code Place - Where Should You Put Your Code?
MAR 06,2020
Clarion has many ways to organize your code: in procedures, routines, classes, etc. Mike Hanson will discuss all (or at least most) of these nooks and crannies, and how they interrelate with each other.

You can meet Alejandro at CIDC 2020 Africa in April!
#551
Stimulsoft Reports And Dashboards Template!
FEB 28,2020
This week, Alejandro will be demonstrating his Stimulsoft Templates! He'll be creating a desktop and NetTalk app from scratch, using Stimulsoft reports .net and javascript versions. Really nice!

You can meet Alejandro at CIDC 2020 Africa in April!
#550
Update on Stimulsoft Reports And Dashboards!
FEB 21,2020
This week, Aleksey will give us a demo of the new features in their latest release of Stimulsoft Reports and Dashboards!

Stimulsoft Reports is an impressive set of reporting components for various platforms, such as the .NET Framework, .NET Core, JavaScript, PHP, Java, and Clarion!

The tool has the powerful multiplatform report engine, easy-to-use to use designer and viewer, a large number of report export formats. Components provide a full cycle of report design on the desktop and in a web browser.

SPECIAL NOTE! THIS WEBINAR TAKES PLACE TWO HOURS EARLIER THAN NORMAL!!!
#549
Official Update.It! Launch!
FEB 14,2020
This week, Update.It! from ohnosoft will be officially released! Join John and Mary as they demonstrate this terrific new product. You'll be able to download and install Update.It! during the webinar, as they take you through how it works (even some of how it works behind-the-scenes). Happy Valentine's Day!
#548
The Definitive Guide To Writing Templates - Part 2
FEB 07,2020
[learning] [templates]

In Webinar 545, Bruce began a series on how to write Templates. This is part 2 of that series. Series: #545, #548, #558, #573 #593

0:00 - Start
0:01 - Introduction
0:08 - Bruce Starts
  • Creating a #Extension template
  • #AT
  • Finding the name of an Embed point
  • Priority
  • %Window
  • ABC Object Embed Points
  • #Include
  • #IF
  • Indenting
  • WHERE
  • PROJECT
  • #GROUP / #INSERT
  • #DECLARE / VarExists
  • #RETURN
  • #CALL
  • #SET
  • #FOR
  • Template Debugging
  • #MESSAGE / #ERROR
#547
There May Be Only One!
JAN 31,2020
THERE MAY BE ONLY ONE! We often need to ensure that only one of something is running. That could be a child within your program, or an instance of your program itself. There are a bunch of ways to crack this nut, and Mike Hanson will discuss and demonstrate various options.
#546
Build Automation With Jenkins!
JAN 24,2020
This week, John Farmer joins us to talk about build automation using Jenkins!

 Jenkins – One of several alternative platforms for automation
 Java based so it can run on different O/S environments
 We’re using Windows today, because we’re building a Clarion app.
 Simple Master instance doing the work or more complex Master/Slave with Build-Agents
 A master instance of Jenkins can perform automation or can control other “Agent” instances on various O/S systems.
#545
The Definitive Guide to Writing Templates - Part 1
JAN 17,2020
[learning] [templates]

Bruce starts a new series on writing templates. From the very beginning. #545, #548, #558, #573 #593
0:00 - Start
0:01 - Introduction
0:27 - Bruce Starts
  • What is a Template
  • Where is the Template Language Documentation
  • Where do template live
  • Registering Templates
  • Template Chains
  • First look at template code
  • Program versus Output (#)
  • Template Variables (%)
  • #Template, Family
  • Creating a new template (Learning.Tpl)
  • Application Options: Registry
  • Types of Templates: Application, Procedure, Extension, Control, Code
  • Creating a #Code template
  • First look at #Prompt
#544
Introducing Update.It!
JAN 10,2020
A few months ago, John was going through the monthly ritual of checking for CapeSoft updates, which involved going to the CapeSoft site, getting the list of downloads, sorting by date, opening an app to see what versions I had installed, downloading them all, finding my passwords, etc etc. There should be a better way right, like an automated way?

Now there is! (well, almost, it's not totally finished but it's close!)

Update.It! will take care of all of this work for you, keeping up with what 3rd party products you have installed and alerting you when new versions are available. It automatically downloads the install files for you, so all you have to do is click "Install". It can store your passwords, serial numbers, and maintenance keys. And more!

We'll be demoing Update.It! during the webinar, but also we'll be going "behind the scenes" and talk about how it was written, what interface decisions were made, and how it works "under the hood".
#543
Interface This!
JAN 03,2020
Mike Hanson likes INTERFACEs, because they make it easier to build programs that are both flexible and manageable. In this session, Mike will explain how interfaces simplify class use within a mutli-app system, without littering your main Clarion LibSrc folder with classes from unrelated systems. Building blocks in action!
#542
Creating A Custom Scheduler With NetTalk!
DEC 20,2019
On the ClarionLive Skype chat, Don posted a youtube video demonstrating a custom scheduler he wrote in NetTalk! There was much interest, and he's volunteered to show us all how he did it! You can view the video here: https://www.youtube.com/watch?v=X89tAhzpQQQ
#541
Eureka! I Finally Get Interfaces!
DEC 13,2019
[learning] [classes] [interfaces] [reflection]

Mike loves generic solutions that can be extended over time without breaking things. Interfaces are one of the tools that can be used to achieve this. Unfortunately, wrapping your head around the use and usefulness of interfaces can be a challenge. Mike is going to revisit Bruce's queue disposer (#535), using interfaces to make it more generic and easily extensible. If you don't yet understand the role of interfaces, this example may induce your Eureka! moment.

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

#540
WhatsApp Template and Services
DEC 06,2019
[3rdparty] [whatsapp] [deveoperteam]

This week, Alejandro will be introducing his new WhatsApp template for Clarion!

0:00 - Start
0:02 - Introduction
0:15 - Alejandro Starts