This week, Peter Hermansen will show us how to create charts and graphs with javascript in Clarion! He'll be using CapeSoft's File Explorer, plus rGraph which is a a free JavaScript library.

So now that everyone has won from last week's Smackdown, we'll proceed to the final piece of the puzzle; sending and receiving data with an API call, typically in JSON!

Last week we gave an overview of consuming APIs without involving Clarion at all. This is because, on Thursday before the webinar, John had developed a class utilizing NetTalk that makes consuming APIs easier, and Bruce looked at it and went "no no no this is not easier" and John said "yes yes yes it is easier" and Bruce explained why it's not easier, and John said "but it is easier" and the only way to solve this is with an API smackdown!

Join us this week as the two battle it out for the easiest way to consume APIs, and we get to where you can actually consume APIs in your Clarion apps!

We've seen how to create them, now how do we consume them? John will review what's needed to consume APIs, look at some tools available, and connect with some services and bring down some API results!

More work on the Class/Template begun waaaay back in Webinar 512!

Last week, Arnold began to build a web service in order to create an API for his program! John and Bruce helped him along, and Arnold was able to create a web server and an API method in an incredibly short amount of time!

But we've just scratched the surface!

Join us as Arnold continues his journey in evaluating what he needs, and continues the process of opening up his data to the outside world!

Arnold wants to do an API for his program, but isn't sure where to start or even what to make available to his customers. John has just written an API using NetTalk for his program, which is currently being used as an interface to an eCommerce website. Bruce has created NetTalk, which makes creating an API server easy-peezy!

Join us as we journey with Arnold in evaluating what he needs, and begin the process of opening up his data to the outside world!

Way back in Webinar 503, Wolfgang Orth did a webinar on checking to make sure your code-signed programs haven't been manipulated. Now he wants to turn it into a class and template! Join us on Wolfgang's journey with Mike Hanson to accomplish his goal!

This week, Mike Hanson finishes sharing his thoughts on the 97 things every software architect should know - 75 down, 22 to go!

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