This app requires JavaScript! Episodes
ClarionLive
See it. Learn it. Share it.
Episodes
#580
Tools and Utilities to make your life easier!
SEP 18,2020
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.
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!
#578
Templates and Classes Oh My! Part 5
SEP 04,2020
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.
#577
Clarion and .NET Interop!
AUG 28,2020
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...!
#576
An Overview of the RYB (Run Your Business) Template Set!
AUG 21,2020
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.
#575
Update.It! Update!
AUG 14,2020
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.
#574
Templates and Classes Oh My! Part 4
AUG 07,2020
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.
#573
The Definitive Guide To Writing Templates - Part 4
JUL 31,2020
In Webinar 545, Bruce began a series on how to write Templates. This is part 4 of that series! Series: #545, #548, #558, #573
#572
Enterprise Data Standards
JUL 24,2020
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
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.
#570
TSPlus Version 14 Review!
JUL 10,2020
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.
#569
Secwin 7 For NetTalk 12 Server
JUL 03,2020
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.... Secwin 7 For NetTalk 12 Server!
#568
Templates and Classes Oh My! Part 2
JUN 26,2020
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.
#567
Do2Class - Easy change from Routine to Class
JUN 19,2020
Advantages of using a local Class as a replacement for Procedure Routines. Do2Class utility makes the required changes for you.
#566
Templates and Classes and Etc. oh my!
JUN 12,2020
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.
#565
Active Directory For Dummies!
JUN 05,2020
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!
#564
Introducing Secwin 7! Licensing
MAY 29,2020
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!
#563
Introducing Secwin 7! Access Control on Desktop
MAY 22,2020
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!

SPECIAL NOTE: The webinar can hold 100 attendees. If you try to enter the webinar and receive a message that the webinar is full, you can view the webinar live using YouTube link above.

We will be monitoring the YouTube chat for questions.
#562
Live Window WYSIWYG Design and PROPs Reflection
MAY 15,2020
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. ]
#561
Passing The Data Baton: Using Zapier To Automate Workflows
MAY 08,2020
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!
#560
Creating SQL Table Scripts With DCT2SQL
MAY 01,2020
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".
#559
Presenting: The Nearly Complete Version 1.0 Database Migration System
APR 24,2020
Mike Gorman says: Guys.. 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

So hope that you will consider spending the time either Live or on a Replay. The entire 250+ slide deck is posted above. I'll be ONLY presenting 40+ slides from that deck.
#558
The Definitive Guide To Writing Templates - Part 3
APR 17,2020
In Webinar 545, Bruce began a series on how to write Templates. This is part 3 of that series! Series: #545, #548, #558, #573
  • 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!).