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!

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!

Mike Hanson continues sharing his thoughts on the 97 things every software architect should know - reaching number 75 during this third episode.

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!!!

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!

Mike Hanson continues sharing his thoughts on the 97 things every software architect should know - reaching number 50 during this second episode.

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!

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.

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)

Mike Hanson reviews 97 Things Every Software Architect Should Know!

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!

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!

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….

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)

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!!!

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.)

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.

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!

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.

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!!!

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!

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!).

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.

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.

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!!!!