ClarionLive
See it. Learn it. Share it.
Episodes
#510
It’s Check-Your-Settings time Part 2!
APR 19,2019
This week we'll do what we didn't finish diong last week ! Clarion 11 has been out for awhile, so now’s a good time to go through and review all the different settings that the Clarion IDE has to offer! This week we’ll finish up going through each and every setting and discussing what our preferred settings are and why!
#509
It’s Check-Your-Settings Time!
APR 12,2019
It’s that time again! Clarion 11 has been out for awhile, so now’s a good time to go through and review all the different settings that the Clarion IDE has to offer! As in the past, we’ll got through each and every setting and discuss what our preferred settings are and why!
#508
Review: 97 Things Every Software Architect Should Know - Part 3
APR 05,2019
Mike Hanson continues sharing his thoughts on the 97 things every software architect should know - reaching number 75 during this third episode.
#507
John Hickey's Birthday SAAS Panel - Part 2
MAR 29,2019
Last week, we had a fantastic panel of Clarion devs talking about SAAS! The panel was excellent (if you haven't watched webinar #506 by now, what are you waiting for??!!), they were so good in fact we've invited them back for Part 2!! We'll continue talking about things like why move to a SAAS model, is a SAAS model right for your product, deciding what services to offer, what technically has to be done, how to determine pricing, how do you migrate existing customer to your new model, how to do updates, how to handle billing, and more!

Tune in for the exciting finale!!!
#506
John Hickey's Birthday SAAS Panel - Part 1
MAR 20,2019
Several Clarion devs have moved to a SAAS (Software As A Service) model. Is this something John should be thinking about doing? Is this something you should be thinking about doing?

Let's have a panel and find out!

We'll talk about things like why move to a SAAS model, is a SAAS model right for your product, deciding what services to offer, what technically has to be done, how to determine pricing, how do you migrate existing customer to your new model, how to do updates, how to handle billing, and more!

If you're thinking about SAAS (and you probably should be!) this is the panel for you!
#505
Review: 97 Things Every Software Architect Should Know - Part 2
MAR 15,2019
1:45
Mike Hanson continues sharing his thoughts on the 97 things every software architect should know - reaching number 50 during this second episode.
#504
What's New At Noyantis!
MAR 08,2019
Andy's been busy! Noyantis is famous for wrapping the Codejock activex controls, which provides updated user interface controls including command bars, ribbon bars, report controls, and property grids! Recently he's added Chilkat controls, which include emailing, json and xml construction, Quickbooks online connectivity, and EasyPost interface, and more!

Join Andy for an update on all the exciting new things you can do with your Clarion application!

BONUS! John Hickey from ClarionLive will be joining Andy LIVE from the Noyantis Studios for this special presentation!
#503
Checking Your Digitally Signed EXE For Tampering!
MAR 01,2019
Code-signing your binaries is a good practise, to ensure your customers, that your programs have not been manipulated and are in the exact state as they left your office. However, even code-signed programs can be manipulated, either by viruses or ill-meaning persons, who alter your products with a HEX-editor. Unfortunately, merely no user will do check the integrity, even if they would know how to do that. In this ClarionLive!-Webinar we show the possibility to do such a sanity check during program-start and give out a warning, in case the certificate is broken.
#502
Duration Entry And Display Part 4!
FEB 22,2019
It takes time to get things done (again!). We often work with time values to indicate WHEN things happen, but that implies that we also have to represent HOW LONG something takes. That's why Mike Hanson decided to tackle Duration entry and display. This will be part 4 of the series. (Part 1 was #491 on Dec 7, Part 2 was #495 on Jan 4, Part 3 was #497 on Jan 18)
#501
Review: 97 Things Every Software Architect Should Know - Part 1
FEB 15,2019
Mike Hanson reviews 97 Things Every Software Architect Should Know!
#500
ClarionLive 500th Webinar Extravaganza!!
FEB 08,2019
We made it all the way to 500! Thanks to all of our presenters, contributors, and viewers for helping us get to this remarkable milestone!!

This week, we welcome Robert Zaunere and Diego Borojovich from SoftVelocity! They'll be stopping by to bring us up-to-date on what's happening at SV!!

Then we'll have a gathering of esteemed Clarion developers, including Bruce Johnson, Mike Hanson, Dave Harms, and Andy Wilton to talk about Clarion past, present, and future! Plus, Mike Hanson will be talking with the panel about a new book he's been reading, "97 Things Every Software Architect Should Know: Collective Wisdom from the Experts".

And we'll talk about the new Clarion 11 release!

Plus, keep your eye out for a special appearance by a beloved, long-time Clarion Host who we've been missing for far too long! Can you guess who it is? :)

Don't miss this once-in-a-lifetime special event, the ClarionLive 500th Webinar Extravaganza!
#499
Introducing StringTheory 3!!!
FEB 01,2019
StringTheory has been a must-have tool for Clarion users since time immemorial! Now StringTheory 3 has arrived with even more functionality and amazingness! Join us this Friday as Bruce takes us through all the nifty new things that StringTheory 3 can do for you!
#498
Mobile Automatic Vehicle Location System
JAN 25,2019
We will be discussing automated vehicle locating (AVL) for a small fleet of vehicles.

Topics:
• Why the project was started
• Technologies / products used
• Problems encountered
• Solutions to problems and hopefully an enlightened discussion on other approaches
• App demonstration
• And probably more….
#497
Duration Entry And Display Part 3!
JAN 18,2019
It takes time to get things done. We often work with time values to indicate WHEN things happen, but that implies that we also have to represent HOW LONG something takes. That's why Mike Hanson decided to tackle Duration entry and display. This will be part 3 of the series. (Part 1 was #491 on Dec 7, Part 2 was #495 on Jan 4)
#496
Using SQL and ODBC in Clarion!
JAN 11,2019
This week Dennis will be talking about ODBC and Clarion! Topics include:

Using ODBC 13.1
Binding columns with ODBC
Binding parameters with ODBC
Using SQLGetDiagField and SQLGetDiagRec for errors
Execute a Query and fill a queue
Execute a Scalar Query get Id value back
Execute a Query with a join clause and fill a queue
Joined table does not have a file definition in the code
Call a Stored procedure and fill a queue, manually connect/disconnect
Call Scalar function get the returned value from the function
Call stored procedure w/out parameter
Call stored procedure w/multiple result sets and one input parameter
And more!!!
#495
Duration Entry And Display Part 2!
JAN 04,2019
From Mike:

It takes time to get things done. We often work with time values to indicate WHEN things happen, but that implies that we also have to represent HOW LONG something takes. That's why Mike Hanson decided to tackle Duration entry and display. This will be part 2 of the series. (Part 1 was #491 on Dec 7.)
#494
Extract Transformation Load Session 2
DEC 28,2018
The Extract Transformation Load system is clearly based on the objectives that JP was attempting to accomplish. It's sad that he passed on and that his product disappeared.

Prior to August 24th, I presented a Clarion Live that showed a way to uncover problems that might exist in a DCT and then what needs to be done to correct them.

On August 24, I did another Clarion Live that represented the core of a ETL system that addressed a good bit of what JP was attempting. Subsequent to the 8/24 presentation, and based on suggestions from others, I spent another 500 hour of development to bring this completed Version 1.0.

Simply put, the ETL system enables you to take an existing SQL database and to migrate it to an upgraded design. By upgraded, you can drop or add columns, you can drop or add tables, and finally you can change column and table names.

Fundamentally while the ETL is accomplished entirely with SQL statements the architecture that manages the ETL execution is entirely done within "traditional" Clarion.

This version enables you to migrate between Mimer databases and between MS/SQL databases. It should also enable you to migrate between Mimer and MS/SQL. In the near future I should be able to add other SQL Engines to the mix as well.

The only SQL engine features that's requires specialized retooling for each new SQL Engine are: 1) Autoincrementing including the resetting of the last "high value," and the specialized commands from within the SQL Engine's schema information tables. These "SQL issues" are quite isolated and will be easy to add.
#493
Case Studies: Creating APIs with NetTalk, Creating Mobile Apps with NetTalk
DEC 21,2018
This week it's two for one!!

John Hickey will be presenting his journey into APIs using NetTalk! He'll talk about the need to allow outside developers to have access client's data, such as customer, inventory, and invoices, and the path he took to provide this functionality!

Don Ridley will be be walking everyone through a basic mobile application built with NetTalk and mBuild. He'll cover setting up an Apple Developer Account, key creation, and, hopefully, using push notifications in mobile/web applications!
#492
Approaches to Certificates and SSL on a LAN or INTRAnet!!
DEC 14,2018
People needing to support HTTPS on internal networks (where servers are not visible on the Internet) have a real challenge in getting appropriate certificates.
This webinar will look at two approaches to this challenge.
Some of the information will be intended for you to share with the corporate IT departments with whom you work.
But we’ll also take a more general look at two of the important components – IP name resolution and certificates/public key infrastructure.
#491
Mystery Webinar!
DEC 07,2018
Phew!! Netvember is over, and what an epic month it was! We now return you to our regular webinar link, with the inimitable Mike Hanson Mystery Webinar!!!

pssst... the mystery was, he's creating a brand new awesome Duration class!!!
#490
NetTalk 11 Desktop!
NOV 30,2018
This week, Bruce wraps up the Netvember megathon with NetTalk 11 Desktop!

This level of NetTalk contains all the basic functionality which your Windows Desktop program will need. This includes all the NetAuto functionality, like NetRefresh and NetAutoClose, NetSimple (server and client) plus classes for SMTP/POP3/IMAP Email, FTP, HTTP and HTTPS WebClient classes and so on. It also includes LDAP, Active Directory, Desktop Maps, OAuth Client and more!
#489
Netvember Thanksgiving Special, Five Tips And Tricks From The ClarionLive Website!
NOV 23,2018
This week is the Netvember Thanksgiving Special! This week, Bruce will be talking about five tips and tricks from the ClarionLive website (just like the title!).
#488
NetTalk 11 Server!
NOV 16,2018
This week, Netvember continues with a deep-dive into NetTalk Server!

NetTalk Server includes all the functionality of NetTalk Desktop but also includes classes and templates for generating highly interactive web applications and/or Web Service API Servers.

Web API Servers (aka Web Services) allow desktop programs from yourself, or anyone else (in any language) to access your data, through a clearly defined interface that you create. Unlike web apps (for which there is a reasonably steep learning curve), creating web services is easy and can be done with very little effort. A typical "newbie" program can have a server written and deployed within a few days.
#487
NetTalk 11 Apps!
NOV 09,2018
Last Friday was the official release of NetTalk 11!! This week, Netvember continues with a deep-dive into NetTalk Apps!

NetTalk Apps is the newest NetTalk level and includes all the functionality in NetTalk Desktop and NetTalk Server. In addition it includes the necessary templates, classes and JavaScript to allow you to create completely stand-along JavaScript applications. These applications can be packaged (without a server) into apps that can be deployed onto any device and which in turn can then run disconnected from the internet on that device.
#486
NetTalk 11 Official Release!!
NOV 02,2018
This Friday is the official release of NetTalk 11!! What's new in NetTalk 11? Only one person knows, and fortunately he'll be with us at the webinar to show us all the amazing capabilities of NetTalk 11!! And not just this week, but the whole month of what we had to call NetVember!!!!