ClarionLive
See it. Learn it. Share it.
Episodes
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!
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!
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….
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!!!
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.)
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.
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.
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!
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!
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.
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!!!
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 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!
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!).
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.
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.
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!!!!
CIDC 2019 Official Announcement! Plus Passing Parameters - Back to Basics - Part 2
OCT 26,2018
What are parameters? What are prototypes? How do you move data between procedures? What can be passed? How do you pass a queue? An object? So many questions! Mike Hanson is back to continue the discussion with examples on passing parameters!
This week, Mark Camfield and Devin Gallagher from AquaFold will be presenting Aqua Data Studio!
Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts. It allows you to develop, access, manage, and visually analyze data. Whether you are working with relational, nosql or cloud databases, your data is easily and quickly accessible with Aqua Data Studio. It supports all major database vendors, works on all major operating systems and is localized to 9 languages.
***********************************************************************************************
Below are the specials and some supporting resources to share about. Please feel free to share with anyone and everyone at ClarionLive.
We can honor these prices for your community through the end of Nov 2018:
• Buy 1 license for $469 ($30 off list of $499)
• 1 license for a 3-Year Term = $799 ($50 off list of $848.30)
• Buy 5/Get 1: Buy five licenses, get the use of the 6th for one year
• 3-Year 5-Pack = $3,798 ($444 off list of $4,242)
If folks would like to check out Aqua Data Studio
- Productivity software for Developers, DBAs, and Analysts
- 38 standalone tools in a single integrated solution supporting 30 database systems
- Allows you to develop, access, manage, and visually analyze data
- Provides easy and quick access to relational, nosql and cloud databases
- Supports all major database vendors, works on all major operating systems - Localized to 9 languages
For more information, please find the attached datasheet and the links below:
ADS Overview Video: https://youtu.be/0F6QLmyR4kM
Who Else Uses ADS?: http://www.aquafold.com/company_customers
Aqua Data Studio 2- Week Free Trial: http://www.aquafold.com/aquadatastudio/trialregform
Contact for Aqua Data Studio:
Jenson Mathai, Regional Account Manager
O: 713.533.5027 | jenson.mathai@idera.com
Mark Camfield, Global Specialist | Aqua Data Studio
O: 713.533.5074 | mark.camfield@idera.com
Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts. It allows you to develop, access, manage, and visually analyze data. Whether you are working with relational, nosql or cloud databases, your data is easily and quickly accessible with Aqua Data Studio. It supports all major database vendors, works on all major operating systems and is localized to 9 languages.
***********************************************************************************************
Below are the specials and some supporting resources to share about. Please feel free to share with anyone and everyone at ClarionLive.
We can honor these prices for your community through the end of Nov 2018:
• Buy 1 license for $469 ($30 off list of $499)
• 1 license for a 3-Year Term = $799 ($50 off list of $848.30)
• Buy 5/Get 1: Buy five licenses, get the use of the 6th for one year
• 3-Year 5-Pack = $3,798 ($444 off list of $4,242)
If folks would like to check out Aqua Data Studio
- Productivity software for Developers, DBAs, and Analysts
- 38 standalone tools in a single integrated solution supporting 30 database systems
- Allows you to develop, access, manage, and visually analyze data
- Provides easy and quick access to relational, nosql and cloud databases
- Supports all major database vendors, works on all major operating systems - Localized to 9 languages
For more information, please find the attached datasheet and the links below:
ADS Overview Video: https://youtu.be/0F6QLmyR4kM
Who Else Uses ADS?: http://www.aquafold.com/company_customers
Aqua Data Studio 2- Week Free Trial: http://www.aquafold.com/aquadatastudio/trialregform
Contact for Aqua Data Studio:
Jenson Mathai, Regional Account Manager
O: 713.533.5027 | jenson.mathai@idera.com
Mark Camfield, Global Specialist | Aqua Data Studio
O: 713.533.5074 | mark.camfield@idera.com
This week, Nick Manteris from Idera will be presenting Rapid SQL! With Rapid SQL you can:
* Create high-performing SQL code on major DBMSs from one interface
* Easily build complex SQL statements with visual query builder
* Quickly construct, analyze and execute SQL code with code analyst
* Simplify debugging SQL code, functions, and stored procedures
* Collaborate effectively across development teams with version control
Contact for DBArtisan and Rapid SQL:
Nick Manteris | Account Executive – Multi Platform Database Solutions
O: 713.285.5331 | nick.manteris@idera.com
Approved Pricing for Clarion Live Members on DBArtisan & Rapid SQL
List Price
• DBArtisan Single Platform Perpetual License $3,567 + Maintenance/Support $892
• DBArtisan Multi-Platform Perpetual License $5,403+ Maintenance/Support $1,351
• Rapid SQL Single Platform Perpetual License $863 + Maintenance/Support $216
• Rapid SQL Multi-Platform Perpetual License $1,294+ Maintenance/Support $324
ClarionLive Pricing
• DBArtisan Single Perpetual License $1,596 + Maintenance/Support $399
• DBArtisan Multi-Platform Perpetual License $2,399 + Maintenance/Support $600
• Rapid SQL Single Platform Perpetual License $476.00 + Maintenance/Support $119
• Rapid SQL Multi-Platform Perpetual License $636 + Maintenance/Support $159
• All offers for Clarion Live include a free licenses of DB Optimizer
* Create high-performing SQL code on major DBMSs from one interface
* Easily build complex SQL statements with visual query builder
* Quickly construct, analyze and execute SQL code with code analyst
* Simplify debugging SQL code, functions, and stored procedures
* Collaborate effectively across development teams with version control
Contact for DBArtisan and Rapid SQL:
Nick Manteris | Account Executive – Multi Platform Database Solutions
O: 713.285.5331 | nick.manteris@idera.com
Approved Pricing for Clarion Live Members on DBArtisan & Rapid SQL
List Price
• DBArtisan Single Platform Perpetual License $3,567 + Maintenance/Support $892
• DBArtisan Multi-Platform Perpetual License $5,403+ Maintenance/Support $1,351
• Rapid SQL Single Platform Perpetual License $863 + Maintenance/Support $216
• Rapid SQL Multi-Platform Perpetual License $1,294+ Maintenance/Support $324
ClarionLive Pricing
• DBArtisan Single Perpetual License $1,596 + Maintenance/Support $399
• DBArtisan Multi-Platform Perpetual License $2,399 + Maintenance/Support $600
• Rapid SQL Single Platform Perpetual License $476.00 + Maintenance/Support $119
• Rapid SQL Multi-Platform Perpetual License $636 + Maintenance/Support $159
• All offers for Clarion Live include a free licenses of DB Optimizer
Computer Vision, Artificial Intelligence, Neural Network, Deep Learning & Clarion Part 2!
OCT 05,2018
Kevin is back to continue his excellent presentation on CV!!
This week, Kevin will be covering:
* Putting a Pi together
* Loading the OS, and testing it,
* Capturing an image from the camera,
* Sending live data to a net talk server from a sensor that is measuring temperature and humidity.
* Sending code from a pc to Pi.
What are parameters? What are prototypes? How do you move data between procedures? What can be passed? How do you pass a queue? An object? So many questions!
Mike Hanson is here to help, with a thorough discussion with examples on passing parameters!
Computer Vision, Artificial Intelligence, Neural Network, Deep Learning & Clarion Part 1!
SEP 21,2018
Learn how to pull in an image from disk or from a video stream!
In part one we learn how to "read" an image in and how to form it into something we can throw a query at.
* Where are the limitations, the draw backs?
* How to extract data to put into our Clarion database
* How to get away from table form to a new way of importing and working on data, visual data.
Applications include:
Licence plates
Faces
Identify objects in an image
See when a some one walks in, how many people walk in or out
Read passorts
and more....
This week, Dominique Benoit will be demonstrating the latest release of TS Plus, focusing on two major features:
Mobile App!!
It is now possible to publish any Clarion Application using an Android, or an IOS App which can be downloaded from Google Play or iTunes!
Cyber Security!!
Cyber Security is a major concern these days; with RDS-Knight you can shield your Clarion servers from any kind of attacks!
Reordering Records - Part Five - Legacy Support
SEP 07,2018
This week, Mike continues on his journey to reorder records with part five of his coding megathon!!!
Copyright 2019