This app requires JavaScript! Episodes
ClarionLive
See it. Learn it. Share it.
Episodes
#710
Redesigning the UltimateDebug Viewer Interface Part 2!
MAY 26,2023
#709
Redesigning the UltimateDebug Viewer Interface!
MAY 19,2023
#708
Johnson vs Hickey in the Heavyweight Debug Title Match of the century - DebugMania!!!
MAY 12,2023
#707
Fun with XML and JSON!
MAY 04,2023
#706
Premier release of DEX Copilot v1.0!
APR 28,2023
#705
Update on Ultimate Everything, EXP Files, and the (not quite) shortest webinar ever
APR 21,2023
#704
Mike/Bruce/Andy - Rewriting A Clarion Example App - The New Voyages - Part 1!
APR 14,2023
#703
Boldly Going Where No One Has Gone Before - Rewriting A Clarion Example App Part 9!
APR 07,2023
#702
Mike Writes A Class To Do Recursive Folders And Files!
MAR 31,2023
#701
What’s Up With G-Visuals And Other Things!
MAR 24,2023
An update on G-Visuals and the upcoming DevExtreme wrapper project!

00:00:00 Intro
00:23:00 Presentation begins
00:25:10 Combo lookup options, review of Template
00:38:15 Demo of automatic cascading update upon data change. Example: City change, State updates
00:46:00 How to put back a control that's been deleted that was part of a template
00:49:54 Enhanced Entries - validation
01:01:24 Applying Anchors to scrollable screens
01:05:35 Scrolling screens, making tabs into a scrollable window automatically (in progress)
01:06:58 Styles - applying styles throughout an application
01:16:24 Replacing text automatically throughout an application - prompts, Grid Control, Task Panel, etc
01:23:12 Animated windows - not in demo yet, allows for moving window onto screen, etc
01:25:20 List monitors, including screen resolutions, position. Set Windows to open on specific monitor, at specific position
01:32:10 DevExtreme progress update
01:40:13 Wrap up
#700
Back To Basics - BITs and BIT functions!
MAR 17,2023
APOLOGIES!
Unfortunately, the recording has constant pauses in it making it very hard to watch. My laptop was losing internet connection and I didn't notice.

A look at BITs and various BIT functions, including BOR and BAND!

#699
A Template for MS SQL Autonumber and how to deal with Identity field Part 2!
MAR 10,2023
A continuation of last weeks webisode!
#698
A Template for MS SQL Autonumber and how to deal with Identity field.
MAR 03,2023
Alexis will show how to set an identity number for sql tables inside the dictionary and a template to deal with this field in the app, also to get the autonumber for keys . This is very useful when you want to convert a tps app to mssql app or start from scratch.
#697
Boldly Going Where No One Has Gone Before - Rewriting A Clarion Example App Part 8!
FEB 24,2023
#696
Looking ahead at noyantis!
FEB 17,2023
The one where Andy announces new and exciting upcoming products, and puts an end to John's bribery scheme.

00:00:00 Intro
00:13:00 Presentation begins
01:00:00 Andy runs overtime
01:08:34 Wrap up
#695
Boldly Going Where No One Has Gone Before - Rewriting A Clarion Example App Part 7!
FEB 10,2023
Boldly Going Where No One Has Gone Before - Rewriting A Clarion Example App Part 7!

00:00:00 Intro
00:18:45 Summary of where we are on rewriting the Invoice example
00:30:12 Coding deleting an invoice detail record
00:32:45 Using the task list ("TODO")
00:34:48 Totaling the invoice detail, tax rates, discounts, subtotals
00:38:40 Setting the Tab order of the fields
01:01:10 Adding the invoice detail calculations
01:11:40 Adding the SaveDetail procedure (updating the invoice detail records in the queue to the sqlite table)
01:37:15 Discussion on using logout/commit
01:53:50 Getting error codes when FileManager has errors
02:14:50 Wrap up

When FileManager has an error, can retrieve with the following:
self.lastError = GlobalErrors.GetError(ErrClarion)
self.lastErrorCode = GlobalErrors.GetErrorCode(ErrClarion)
self.lastFileError = GlobalErrors.GetError(ErrFile)
self.lastFileErrorCode = GlobalErrors.GetErrorCode(ErrFile)
#694
Boldly Going Where No One Has Gone Before - Rewriting A Clarion Example App Part 6!
FEB 03,2023
00:00:00 Intro
00:13:00 Presentation starts - summary of where we are
00:15:55 Reviewing the .LoadDetail method
00:19:50 Writing the .InsertRecord method
00:28:45 Writing the .ChangeRecord method
00:42:15 View structure, does it project all fields in a join?
00:43:10 Creating the update form
00:58:20 Save and Restore state with Lookup template
01:16:10 UpdateInvoiceDetail - Calculating the totals with tax
01:29:30 Testing adding a product
01:53:45 Using Carl's sample data generator
01:57:29 Wrap up
#693
Boldly Going Where No One Has Gone Before - Rewriting A Clarion Example App Part 5!
JAN 27,2023
#692
Testing The Invoice Example; SQLite issues and oddities!
JAN 20,2023
#691
Boldly Going Where No One Has Gone Before - Rewriting A Clarion Example App Part 4!
JAN 13,2023
#690
Boldly Going Where No One Has Gone Before - Rewriting A Clarion Example App Part 3!
JAN 06,2023
#689
The Year In Reflection!
DEC 30,2022
00:00:00 Intro 00:03:00 Welcome 00:13:00 Announcements - CIDC 2023! It's a thing! 00:25:00 Feature Presentation - Year End Reflection 00:32:00 CIDC Africa Discussion 00:38:00 Mark - Thank you for webinars 00:40:30 Doug - Clarion Predictions from each host 00:52:00 Tips for the year! 01:03:00 John - Thank yous! 01:06:00 Cape Town The Series 01:11:00 Wrap Up
#688
Boldly Going Where No One Has Gone Before - Rewriting A Clarion Example App Part 2!
DEC 23,2022
00:00:00 Intro
00:10:03 Discussion on external names
00:22:41 Discussion on using prefix_fieldname for external name
00:29:38 Presentation begins - Dictionary review
00:35:55 Using the Wizard to create the application
00:37:25 Customizing the Wizard
00:47:00 Creating the MakeGUID Procedure
00:55:05 Discussion on using a Manifest
00:56:18 Creating the Toolbar
01:20:23 Adding Icons to the Toolbar
01:47:44 Designing a Browse
02:03:38 Wrap Up
#687
Extending NetTalk - Thinking Outside The Box!
DEC 16,2022
#686
Free Easy Time Template (DateTime, countdown, stopwatch classes)
DEC 09,2022