# tips **URL:** https://clarionhub.com/c/questions/tips/21.md [Latest](https://clarionhub.com/latest.md) · [Categories](https://clarionhub.com/categories.md) · [Tags](https://clarionhub.com/tags.md) --- ## [About the tips category](https://clarionhub.com/t/about-the-tips-category/175)
**Author:** [@brahn](https://clarionhub.com/u/brahn)\ **Replies:** 0
A place for HowTos, Hint and Tips. Clarion related is probably best but feel free to just go with anything useful! --- ## [XERO API OAuth 2 Interface](https://clarionhub.com/t/xero-api-oauth-2-interface/9396)
**Author:** [@Marius\_Nel](https://clarionhub.com/u/Marius_Nel)\ **Replies:** 1\ **Last updated:** [September 25, 2026, 3:11pm UTC](https://clarionhub.com/t/xero-api-oauth-2-interface/9396 "2026-09-25T15:11:20Z")
Hello all, We are busy with the XERO API but when we enter our server https://www.ourserver.com \[example\] as the redirect URL we get error 500. if we enter \[https://oauth.pstmn.io/v1/callback\] it works 100% (Even when … --- ## [FILEDIALOG(...FILE:Directory) to select folder may crash with OneDrive; use IFILEDIALOG instead](https://clarionhub.com/t/filedialog-file-directory-to-select-folder-may-crash-with-onedrive-use-ifiledialog-instead/9217)
**Author:** [@RichCPT](https://clarionhub.com/u/RichCPT)\ **Replies:** 9\ **Last updated:** [September 16, 2026, 6:20pm UTC](https://clarionhub.com/t/filedialog-file-directory-to-select-folder-may-crash-with-onedrive-use-ifiledialog-instead/9217 "2026-09-16T18:20:03Z")
When Clarion’s runtime FILEDIALOG procedure is used as a folder picker (using the FILE:Directory option), users can easily crash the application when browsing OneDrive-backed folders, and possibly other virtual folders. … --- ## [Test if Close(Report) is SLOW on your System? – Mine 100x slower than C6](https://clarionhub.com/t/test-if-close-report-is-slow-on-your-system-mine-100x-slower-than-c6/4491)
**Author:** [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\ **Replies:** 31\ **Last updated:** [August 25, 2026, 7:43pm UTC](https://clarionhub.com/t/test-if-close-report-is-slow-on-your-system-mine-100x-slower-than-c6/4491 "2026-08-25T19:43:09Z")
I noticed when large 1000+ page Reports closed Preview there was an obvious pause of 10+ seconds before focus returned to the calling window. I traced this down to CLOSE(Report) which deletes the WMF files in the Temp fo… --- ## [Code Signing with Azure](https://clarionhub.com/t/code-signing-with-azure/9305)
**Author:** [@RayRippey](https://clarionhub.com/u/RayRippey)\ **Replies:** 4\ **Last updated:** [August 19, 2026, 7:10pm UTC](https://clarionhub.com/t/code-signing-with-azure/9305 "2026-08-19T19:10:08Z")
I’m not sure how much I can put here. I used ChatGPT to walk me through creating an account with Azure and creating a certificate for code signing. Then I had it summarize. Here are the results, hope it helps someone. If… --- ## [Nettalk and PassKey!](https://clarionhub.com/t/nettalk-and-passkey/9270)
**Author:** [@Omar\_Squiabro](https://clarionhub.com/u/Omar_Squiabro)\ **Replies:** 3\ **Last updated:** [August 11, 2026, 6:57pm UTC](https://clarionhub.com/t/nettalk-and-passkey/9270 "2026-08-11T18:57:10Z")
Today I finally managed to integrate the Pass key into a Nettalk application, and everything works correctly, using the latest version of WebAuth and its encryption. Everything works perfectly. Everything is integrated i… --- ## [Fake Setup Clarion 9 to install older Accessory Setups like BoTpl](https://clarionhub.com/t/fake-setup-clarion-9-to-install-older-accessory-setups-like-botpl/4231)
**Author:** [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\ **Replies:** 8\ **Last updated:** [August 10, 2026, 10:41am UTC](https://clarionhub.com/t/fake-setup-clarion-9-to-install-older-accessory-setups-like-botpl/4231 "2026-08-10T10:41:46Z")
Based on discussion in the Changes Topic there are old Setup Builder Clarion Accessory installers that work with a maximum of Clarion 8, 9 or 9.1. Attached is a simple Clarion program "Fake Setup Clarion 9" that creates… --- ## [What does "Internal Error: ISL ERROR: 0" mean?](https://clarionhub.com/t/what-does-internal-error-isl-error-0-mean/267)
**Author:** [@brahn](https://clarionhub.com/u/brahn)\ **Replies:** 9\ **Last updated:** [July 27, 2026, 12:40pm UTC](https://clarionhub.com/t/what-does-internal-error-isl-error-0-mean/267 "2026-07-27T12:40:22Z")
It is a good idea not to try and create a class with the same label as a table in the DCT. At least in my case it wasn’t, I was getting a bunch of silly compiler errors and one that I had not seen before ISL ERROR: 0. Re… --- ## [How to bypass code signing in SetupBuilder](https://clarionhub.com/t/how-to-bypass-code-signing-in-setupbuilder/9241)
**Author:** [@RayRippey](https://clarionhub.com/u/RayRippey)\ **Replies:** 3\ **Last updated:** [July 22, 2026, 8:34pm UTC](https://clarionhub.com/t/how-to-bypass-code-signing-in-setupbuilder/9241 "2026-07-22T20:34:18Z")
So my Code sign is expired thanks to Sectigo ripping me off for a full year... and not replying when I pointed it out on the invoice that is on their site. Anyway, I just want to test the program (we use it as well), so… --- ## [Builtin symbol %OutputOffset only works when not using #\[Empty|Pre|Post\]Embed](https://clarionhub.com/t/builtin-symbol-outputoffset-only-works-when-not-using-empty-pre-post-embed/9223)
**Author:** [@RchdR](https://clarionhub.com/u/RchdR)\ **Replies:** 0\ **Last updated:** [July 11, 2026, 10:54am UTC](https://clarionhub.com/t/builtin-symbol-outputoffset-only-works-when-not-using-empty-pre-post-embed/9223 "2026-07-11T10:54:12Z")
Header Changed from : Builtin symbol %OutputOffset doesnt exist to: Builtin symbol %OutputOffset only works when not using #\[Empty|Pre|Post\]Embed TLDR %Embed\[ID|Description|Parameters\] works as parameters inside #\[Emp… --- ## [\#EmptyEmbed, #PreEmbed, #PostEmbed](https://clarionhub.com/t/emptyembed-preembed-postembed/9215)
**Author:** [@RchdR](https://clarionhub.com/u/RchdR)\ **Replies:** 0\ **Last updated:** [July 7, 2026, 7:31pm UTC](https://clarionhub.com/t/emptyembed-preembed-postembed/9215 "2026-07-07T19:31:45Z")
These template functions are missing a pertinent bit of info from the docs. They can only be used in the parent section. Add to #Application to use in #Module and #Procedure. Add to #Module to use in #Procedure. I kn… --- ## [Problem with SetupBuilder - Icons didn’t show up in the Start Menu using Start11](https://clarionhub.com/t/problem-with-setupbuilder-icons-didn-t-show-up-in-the-start-menu-using-start11/9107)
**Author:** [@RayRippey](https://clarionhub.com/u/RayRippey)\ **Replies:** 10\ **Last updated:** [May 16, 2026, 12:40am UTC](https://clarionhub.com/t/problem-with-setupbuilder-icons-didn-t-show-up-in-the-start-menu-using-start11/9107 "2026-05-16T00:40:36Z")
All of a sudden today when I created a new install using Setup Builder, the icons didn't show up in the start menu. I have Digital Wrench, then the folder Digital Wrench which is under start menu/programs, and the shortc… --- ## [Tricks to get Cybersource Credit card processing post to work](https://clarionhub.com/t/tricks-to-get-cybersource-credit-card-processing-post-to-work/9068)
**Author:** [@JeffH](https://clarionhub.com/u/JeffH)\ **Replies:** 0\ **Last updated:** [April 23, 2026, 3:00pm UTC](https://clarionhub.com/t/tricks-to-get-cybersource-credit-card-processing-post-to-work/9068 "2026-04-23T15:00:09Z")
MAP CyberSource:GenerateSignatureFromParams PROCEDURE (STRING signatureParams,STRING secretKey),STRING END MAP CyberSource:GenerateHeader PROCEDURE (\*typCCRetailMsg ccMsg, \*NetWebClient pWeb, STRING PostString) EN… --- ## [Reading Errors after ACCESS calls](https://clarionhub.com/t/reading-errors-after-access-calls/9054)
**Author:** [@Bruce](https://clarionhub.com/u/Bruce)\ **Replies:** 2\ **Last updated:** [April 18, 2026, 4:46am UTC](https://clarionhub.com/t/reading-errors-after-access-calls/9054 "2026-04-18T04:46:46Z")
It is well known that the following code is wrong; If Access:table:Whatever \<\> Level:Benign lastError = Errorcode() End This is because the ABC Methods explicitly do not preserve the actual ErrorCode et al fro… --- ## [Microsoft Trusted Code Signing (Friedrich) (it works!)](https://clarionhub.com/t/microsoft-trusted-code-signing-friedrich-it-works/7666)
**Author:** [@Jane](https://clarionhub.com/u/Jane)\ **Replies:** 32\ **Last updated:** [April 14, 2026, 6:11am UTC](https://clarionhub.com/t/microsoft-trusted-code-signing-friedrich-it-works/7666 "2026-04-14T06:11:07Z")
Friedrich seems to have enjoyed his nap :wink: and has been back - posting on the newsgroups and on his forum. Latest post is about a code-signing technology of which I hadn't heard - Microsoft Trusted Code Signing. A… --- ## [Validating email addresses](https://clarionhub.com/t/validating-email-addresses/9015)
**Author:** [@RchdR](https://clarionhub.com/u/RchdR)\ **Replies:** 9\ **Last updated:** [March 28, 2026, 8:16pm UTC](https://clarionhub.com/t/validating-email-addresses/9015 "2026-03-28T20:16:13Z")
There are times when not to use RegEx’s. For example, the common RegEx for valid email addresses doesnt work. Not every mail server conforms to the standards, so the easiest thing I did in the past was to have a button… --- ## [Net talk email Oauth2 Step by Step for outlook, Code for Gmail. Yahoo not working!](https://clarionhub.com/t/net-talk-email-oauth2-step-by-step-for-outlook-code-for-gmail-yahoo-not-working/7870)
**Author:** [@JeffH](https://clarionhub.com/u/JeffH)\ **Replies:** 33\ **Last updated:** [March 7, 2026, 3:20pm UTC](https://clarionhub.com/t/net-talk-email-oauth2-step-by-step-for-outlook-code-for-gmail-yahoo-not-working/7870 "2026-03-07T15:20:54Z")
This is a document of how I created an Oauth2 account with office365. It may not be 100% accurate. Give it a try if you have never tried to send email using Oauth2. Setup outlook for Oauth2 and email Register at this p… --- ## [Change mouse cursor based on column in browse](https://clarionhub.com/t/change-mouse-cursor-based-on-column-in-browse/8920)
**Author:** [@xxetfxx](https://clarionhub.com/u/xxetfxx)\ **Replies:** 12\ **Last updated:** [February 12, 2026, 1:45am UTC](https://clarionhub.com/t/change-mouse-cursor-based-on-column-in-browse/8920 "2026-02-12T01:45:28Z")
Hello, Is there a way to change the mouse cursor icon when you point the mouse to a certain column you want to set? I am trying to mimic an action button per record. Thanks. --- ## [Accessing a Web Service that uses Microsoft Single Sign On for OAuth](https://clarionhub.com/t/accessing-a-web-service-that-uses-microsoft-single-sign-on-for-oauth/8933)
**Author:** [@PaulMacFarlane](https://clarionhub.com/u/PaulMacFarlane)\ **Replies:** 7\ **Last updated:** [February 9, 2026, 6:08pm UTC](https://clarionhub.com/t/accessing-a-web-service-that-uses-microsoft-single-sign-on-for-oauth/8933 "2026-02-09T18:08:32Z")
Does anyone have a NetTalk example of this? --- ## [Installing a Clarion application on Xubuntu using Wine and setting up a nettalk web server (Part 1) - (Part 2) - (Part 3)](https://clarionhub.com/t/installing-a-clarion-application-on-xubuntu-using-wine-and-setting-up-a-nettalk-web-server-part-1-part-2-part-3/8927)
**Author:** [@JeffH](https://clarionhub.com/u/JeffH)\ **Replies:** 11\ **Last updated:** [February 9, 2026, 6:06pm UTC](https://clarionhub.com/t/installing-a-clarion-application-on-xubuntu-using-wine-and-setting-up-a-nettalk-web-server-part-1-part-2-part-3/8927 "2026-02-09T18:06:24Z")
The following are step by step instructions for installing Xubuntu and Wine in a Hyper-V VM running on OVH and Local hosted VM’s Installing xubuntu and wine Ovh to use static IP you must create a mac address in the OVH… --- ## [Moving beyond Clarion 10 11897 (Cross-Thread Deadlock Silent GPF's)](https://clarionhub.com/t/moving-beyond-clarion-10-11897-cross-thread-deadlock-silent-gpfs/2544)
**Author:** [@ljwilson](https://clarionhub.com/u/ljwilson)\ **Replies:** 10\ **Last updated:** [February 1, 2026, 3:35am UTC](https://clarionhub.com/t/moving-beyond-clarion-10-11897-cross-thread-deadlock-silent-gpfs/2544 "2026-02-01T03:35:48Z")
Back in September 2017 I first put into production an application that worked fine with C10 11897, but with C10 12799 would occasionally (as in maybe once a week, or 5 times in a day) give silent gpf’s on certain worksta… --- ## [Show PNG in a List or Browser](https://clarionhub.com/t/show-png-in-a-list-or-browser/8912)
**Author:** [@elextronika](https://clarionhub.com/u/elextronika)\ **Replies:** 6\ **Last updated:** [January 30, 2026, 12:36am UTC](https://clarionhub.com/t/show-png-in-a-list-or-browser/8912 "2026-01-30T00:36:35Z")
Is 2026 does anybody created a browser or a list that will show a png or selling a template not a wraper . I need to show a list of pictures , just the name and the picture.I tried with browser grid no luck. --- ## [Generically Remove or Rename a specific TPS Table in a Superfile](https://clarionhub.com/t/generically-remove-or-rename-a-specific-tps-table-in-a-superfile/8887)
**Author:** [@jslarve](https://clarionhub.com/u/jslarve)\ **Replies:** 10\ **Last updated:** [January 6, 2026, 7:10pm UTC](https://clarionhub.com/t/generically-remove-or-rename-a-specific-tps-table-in-a-superfile/8887 "2026-01-06T19:10:23Z")
When you do a REMOVE(TpsSuperFileTable), the RTL/Driver doesn’t need to know the the table structure. This is an example commandline (not console, but could be) app for removing a table from a tps file. TPS Table Remove… --- ## [Frame Menu only allows running One Item due to APPLICATION MenuBar NoMerge](https://clarionhub.com/t/frame-menu-only-allows-running-one-item-due-to-application-menubar-nomerge/3934)
**Author:** [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\ **Replies:** 2\ **Last updated:** [December 24, 2025, 10:48am UTC](https://clarionhub.com/t/frame-menu-only-allows-running-one-item-due-to-application-menubar-nomerge/3934 "2025-12-24T10:48:21Z")
Suddenly the Frame Menu is only allowing One Item to be running i.e. Start 1 thread. The menus drop and appear to work but do nothing. Tested simple things like Printer Dialog and clicking that Item also did nothing, it … --- ## [Disable(0) - Window frozen - Responds to Esc key - New in Clarion 11.1](https://clarionhub.com/t/disable-0-window-frozen-responds-to-esc-key-new-in-clarion-11-1/4400)
**Author:** [@Bruce](https://clarionhub.com/u/Bruce)\ **Replies:** 19\ **Last updated:** [December 16, 2025, 9:04pm UTC](https://clarionhub.com/t/disable-0-window-frozen-responds-to-esc-key-new-in-clarion-11-1/4400 "2025-12-16T21:04:07Z")
So, this isn't a bug, but a difference in behaviour between Clarion 11.0 (build 13630 and earlier) and Clarion 11.1 In Clarion 11.0 and earlier calling Disable(0) appears to have no effect. In Clarion 11.1 calling Di… --- ## [Microsoft Trusted Code Signing - Steps to set it up](https://clarionhub.com/t/microsoft-trusted-code-signing-steps-to-set-it-up/7861)
**Author:** [@MarkGoldberg](https://clarionhub.com/u/MarkGoldberg)\ **Replies:** 57\ **Last updated:** [December 3, 2025, 3:39pm UTC](https://clarionhub.com/t/microsoft-trusted-code-signing-steps-to-set-it-up/7861 "2025-12-03T15:39:34Z")
Here is the process which I'm guessing you need to follow for Trusted Signing (FAQ) It's from memory, and I had a LOT of mis-steps along the way so please help me to refine these steps I started from scratch, Create a … --- ## [CPCS improve DisplayProgress Routine for Faster Reports](https://clarionhub.com/t/cpcs-improve-displayprogress-routine-for-faster-reports/8804)
**Author:** [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\ **Replies:** 4\ **Last updated:** [November 23, 2025, 5:45pm UTC](https://clarionhub.com/t/cpcs-improve-displayprogress-routine-for-faster-reports/8804 "2025-11-23T17:45:37Z")
Reports run slower when the progress window is updated or DISPLAY() too much. This matters most when you have files with large record counts. Lee @lodestar is the report master here, and maintains CPCS, so hopefully he’l… --- ## [Windows 11 "Smart App Control" slows down start of Clarion](https://clarionhub.com/t/windows-11-smart-app-control-slows-down-start-of-clarion/8805)
**Author:** [@e\_mano\_e](https://clarionhub.com/u/e_mano_e)\ **Replies:** 0\ **Last updated:** [November 21, 2025, 11:03pm UTC](https://clarionhub.com/t/windows-11-smart-app-control-slows-down-start-of-clarion/8805 "2025-11-21T23:03:31Z")
I’ve just got a new Lenovo notebook on which I installed a fresh Windows 11 Version 25H2. The Notebook specs are: Core Ultra 7 255H / 16 GB RAM. After installing all apps and all Clarion related things I’ve noticed tha… --- ## [Win 11 : End Task option from Taskbar](https://clarionhub.com/t/win-11-end-task-option-from-taskbar/8734)
**Author:** [@RchdR](https://clarionhub.com/u/RchdR)\ **Replies:** 3\ **Last updated:** [October 29, 2025, 5:39pm UTC](https://clarionhub.com/t/win-11-end-task-option-from-taskbar/8734 "2025-10-29T17:39:41Z")
I think this option appeared in 25H2 release of Win11. Settings (Gear Cog), System \> Advanced \> End Task - Enable end task in taskbar by right click. Switch on or off. --- ## [Commercial SSL certs and NetTalk Web Server](https://clarionhub.com/t/commercial-ssl-certs-and-nettalk-web-server/3721)
**Author:** [@mriffey](https://clarionhub.com/u/mriffey)\ **Replies:** 8\ **Last updated:** [October 16, 2025, 7:02pm UTC](https://clarionhub.com/t/commercial-ssl-certs-and-nettalk-web-server/3721 "2025-10-16T19:02:38Z")
Posted in the newsgroups by Jane Fleming: If you're trying to take a PFX file from a commercial source and split that into unencrypted key and certificate files for use with NT, you can download OpenSSL and use these… [Next page](https://clarionhub.com/c/questions/tips/21.md?page=1)