# tips **URL:** https://clarionhub.com/c/questions/tips/21.md?page=1 [Latest](https://clarionhub.com/latest.md) · [Categories](https://clarionhub.com/categories.md) · [Tags](https://clarionhub.com/tags.md) **Page:** 2 --- ## [TLS/SSL certificates on (internal) LAN](https://clarionhub.com/t/tls-ssl-certificates-on-internal-lan/4894)
**Author:** [@Jane](https://clarionhub.com/u/Jane)\ **Replies:** 17\ **Last updated:** [September 26, 2025, 2:50am UTC](https://clarionhub.com/t/tls-ssl-certificates-on-internal-lan/4894 "2025-09-26T02:50:49Z")
Every so often the question is raised about how to do TLS (SSL) on a LAN (internal) network. While there’s no perfect solution, it can be done by someone who has a smattering of networking knowledge (at least a basic un… --- ## [How to disable Edit in Place for a column at runtime](https://clarionhub.com/t/how-to-disable-edit-in-place-for-a-column-at-runtime/2737)
**Author:** [@Rick\_UpperPark](https://clarionhub.com/u/Rick_UpperPark)\ **Replies:** 13\ **Last updated:** [September 5, 2025, 9:13am UTC](https://clarionhub.com/t/how-to-disable-edit-in-place-for-a-column-at-runtime/2737 "2025-09-05T09:13:19Z")
If you want to conditionally disable edit in place for column you can use the EIPManager’s GetEdit() method to accomplish this. GetEdit returns true or false indicating whether or not EIP is valid for the current column… --- ## [How to Dynamically Load DLL's and Call Procedures by Address](https://clarionhub.com/t/how-to-dynamically-load-dlls-and-call-procedures-by-address/5444)
**Author:** [@anon23294430](https://clarionhub.com/u/anon23294430)\ **Replies:** 31\ **Last updated:** [August 23, 2025, 9:09am UTC](https://clarionhub.com/t/how-to-dynamically-load-dlls-and-call-procedures-by-address/5444 "2025-08-23T09:09:08Z")
Edit Changed title from GetProcAddress & Alexey’s Assembler code to pass additional parameters, & Larry Sand’s Cmag and Paul Attryde’s post on calling a DLL at runtime, ie not statically linked To How to dynamically l… --- ## [Assigning hex values](https://clarionhub.com/t/assigning-hex-values/8474)
**Author:** [@RchdR](https://clarionhub.com/u/RchdR)\ **Replies:** 3\ **Last updated:** [August 13, 2025, 5:15pm UTC](https://clarionhub.com/t/assigning-hex-values/8474 "2025-08-13T17:15:47Z")
Learnt something new about clarion. !Loc:BMI.BMI:bmiColors.rgbRed = FFh !255 - Syntax Error: Unknown Identifier FFh Loc:BMI.BMI:bmiColors.rgbRed = 000000FFh !255 Anyone know why only a 4 byt… --- ## [.NET Managed DLL passing and receiving information](https://clarionhub.com/t/net-managed-dll-passing-and-receiving-information/8467)
**Author:** [@Bjarne\_Havnen](https://clarionhub.com/u/Bjarne_Havnen)\ **Replies:** 4\ **Last updated:** [August 12, 2025, 9:48am UTC](https://clarionhub.com/t/net-managed-dll-passing-and-receiving-information/8467 "2025-08-12T09:48:02Z")
Thought I share a tip when passing information to and from .NET assemblies. I am giving up getting full support for unicode characters in my e-mails and am looking into sending my e-mails from .NET instead. I have alwa… --- ## [Tutorial:How to break into a running Clarion app with the Debugger. - open for criticism & suggestions](https://clarionhub.com/t/tutorial-how-to-break-into-a-running-clarion-app-with-the-debugger-open-for-criticism-suggestions/8430)
**Author:** [@RchdR](https://clarionhub.com/u/RchdR)\ **Replies:** 5\ **Last updated:** [July 29, 2025, 9:47pm UTC](https://clarionhub.com/t/tutorial-how-to-break-into-a-running-clarion-app-with-the-debugger-open-for-criticism-suggestions/8430 "2025-07-29T21:47:30Z")
Comments welcome, hope you find it useful if you didnt know about this. --- ## [Version control for the Clarion folder: using a whitelist approach for .gitignore](https://clarionhub.com/t/version-control-for-the-clarion-folder-using-a-whitelist-approach-for-gitignore/8324)
**Author:** [@CarlosGtrz](https://clarionhub.com/u/CarlosGtrz)\ **Replies:** 5\ **Last updated:** [June 23, 2025, 9:04pm UTC](https://clarionhub.com/t/version-control-for-the-clarion-folder-using-a-whitelist-approach-for-gitignore/8324 "2025-06-23T21:04:35Z")
It's a good idea to have Clarion itself under version control, so you can check what was changed in the templates or classes when upgrading accessories or versions. But Clarion has many directories with a combination of… --- ## [RANDOM is broken in C11.1.13815](https://clarionhub.com/t/random-is-broken-in-c11-1-13815/6938)
**Author:** [@Mike\_Duglas](https://clarionhub.com/u/Mike_Duglas)\ **Replies:** 12\ **Last updated:** [May 26, 2025, 5:28pm UTC](https://clarionhub.com/t/random-is-broken-in-c11-1-13815/6938 "2025-05-26T17:28:56Z")
Simple code that produces a sequence of random numbers: PROGRAM MAP INCLUDE('printf.inc'), ONCE END i LONG, AUTO v LONG, AUTO CODE LOOP i=1 TO 10 … --- ## [Windows Services ( Including Nettalk websites ) and using SYSTEM{PROP:HIDE}=TRUE](https://clarionhub.com/t/windows-services-including-nettalk-websites-and-using-system-prop-hide-true/7859)
**Author:** [@JeffH](https://clarionhub.com/u/JeffH)\ **Replies:** 6\ **Last updated:** [January 29, 2025, 10:26am UTC](https://clarionhub.com/t/windows-services-including-nettalk-websites-and-using-system-prop-hide-true/7859 "2025-01-29T10:26:09Z")
I started using windows services many years ago to automate many of the tasks that I do and that my clients need. I would get system hangs on many of the services on a monthly basis. Just over 2 years ago I implemented a… --- ## [Very slow initial execution of an EXE - solved, it´s AV](https://clarionhub.com/t/very-slow-initial-execution-of-an-exe-solved-it-s-av/7408)
**Author:** [@Rudik](https://clarionhub.com/u/Rudik)\ **Replies:** 10\ **Last updated:** [December 15, 2024, 12:30pm UTC](https://clarionhub.com/t/very-slow-initial-execution-of-an-exe-solved-it-s-av/7408 "2024-12-15T12:30:55Z")
I have noticed a very slow first execution of my EXE on my PC. This was extreme when I copied the new EXE and DLLs into another directory (e.g. real data) and then executed the EXE. The waiting times were sometimes 8 sec… --- ## [Printing Avery Labels - 65 per page](https://clarionhub.com/t/printing-avery-labels-65-per-page/7689)
**Author:** [@Julian](https://clarionhub.com/u/Julian)\ **Replies:** 4\ **Last updated:** [November 26, 2024, 12:41am UTC](https://clarionhub.com/t/printing-avery-labels-65-per-page/7689 "2024-11-26T00:41:56Z")
I found myself needing to print labels recently (the Avery self-adhesive type, 65 per page) but the HELP isn't very helpful. I have battled with this task in the past without success but the solution is oh-so-simple, I h… --- ## [Entry @d1 Bug when 4 Digit Year is entered it flips Month and Day](https://clarionhub.com/t/entry-d1-bug-when-4-digit-year-is-entered-it-flips-month-and-day/7550)
**Author:** [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\ **Replies:** 5\ **Last updated:** [October 13, 2024, 8:12am UTC](https://clarionhub.com/t/entry-d1-bug-when-4-digit-year-is-entered-it-flips-month-and-day/7550 "2024-10-13T08:12:05Z")
An ENTRY(@d1) is format MM/DD/YY with a 2 digit year. Entering dates in Clarion is very flexible and converts to the Entry Picture e.g. you can omit the slashes. I found a bug that if a 4 digit Year is entered into a EN… --- ## [New Intel Wifi adapter setting that can benefit Clarion apps](https://clarionhub.com/t/new-intel-wifi-adapter-setting-that-can-benefit-clarion-apps/7484)
**Author:** [@RchdR](https://clarionhub.com/u/RchdR)\ **Replies:** 0\ **Last updated:** [September 21, 2024, 12:19am UTC](https://clarionhub.com/t/new-intel-wifi-adapter-setting-that-can-benefit-clarion-apps/7484 "2024-09-21T00:19:35Z")
Been going through the settings of Intel Wifi adapters and noticed a new setting. Advanced Intel® Wireless Adapter Settings Global BG scan blocking By default, the Wi-Fi adapter will perform periodic scan for other a… --- ## [Exported Procedure Prototype Mangle Limited to 2 Source Lines by Templates](https://clarionhub.com/t/exported-procedure-prototype-mangle-limited-to-2-source-lines-by-templates/7396)
**Author:** [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\ **Replies:** 11\ **Last updated:** [August 14, 2024, 5:48pm UTC](https://clarionhub.com/t/exported-procedure-prototype-mangle-limited-to-2-source-lines-by-templates/7396 "2024-08-14T17:48:40Z")
A topic the Compiler hangs in Debug mode drifted into a discussion Export Mangle problems so I am creating a separate topic. If a Procedure Prototype is declared using 3 or more source lines then the Mangled name the Te… --- ## [AnyScreen - Adding to a 100% Hand Coded Project](https://clarionhub.com/t/anyscreen-adding-to-a-100-hand-coded-project/5397)
**Author:** [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\ **Replies:** 2\ **Last updated:** [August 8, 2024, 7:37pm UTC](https://clarionhub.com/t/anyscreen-adding-to-a-100-hand-coded-project/5397 "2024-08-08T19:37:57Z")
The topic " Implementing AnySreen in a 100% hand-coded application " is in the AnyScreen help and just documents adding 2 AS lines of code. MAP ... INCLUDE('AnyScreen.inc') ! Add #1 ... CODE AnyScreen:Init() … --- ## [FIXED statement in EXP for 4% smaller EXE without .reloc table](https://clarionhub.com/t/fixed-statement-in-exp-for-4-smaller-exe-without-reloc-table/3450)
**Author:** [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\ **Replies:** 14\ **Last updated:** [July 22, 2024, 8:44pm UTC](https://clarionhub.com/t/fixed-statement-in-exp-for-4-smaller-exe-without-reloc-table/3450 "2024-07-22T20:44:08Z")
In your EXE Global Embed "Creating the Export file" add a line with just "FIXED" and the Linker will not generate a Relocation section (.reloc) making the EXE smaller. The link will probably run a tiny bit faster. The EX… --- ## [SortHeaderClassType.GetColumnLabel - Template fault (Short 1 letter)](https://clarionhub.com/t/sortheaderclasstype-getcolumnlabel-template-fault-short-1-letter/7328)
**Author:** [@Michael\_Boorman](https://clarionhub.com/u/Michael_Boorman)\ **Replies:** 0\ **Last updated:** [July 18, 2024, 1:59pm UTC](https://clarionhub.com/t/sortheaderclasstype-getcolumnlabel-template-fault-short-1-letter/7328 "2024-07-18T13:59:05Z")
Hey Guys Found a small issue in the Browse Class - SortHeaderClassType.GetColumnLabel The call returns the field name with out the Table Prefix - however the last letter of the field name is always left off. I would r… --- ## [Clarion 11.1.13855 EE: broken Message() - Font Size 11 Calcs Wrong Height Clips Text](https://clarionhub.com/t/clarion-11-1-13855-ee-broken-message-font-size-11-calcs-wrong-height-clips-text/6768)
**Author:** [@Genricke](https://clarionhub.com/u/Genricke)\ **Replies:** 10\ **Last updated:** [July 5, 2024, 5:13am UTC](https://clarionhub.com/t/clarion-11-1-13855-ee-broken-message-font-size-11-calcs-wrong-height-clips-text/6768 "2024-07-05T05:13:00Z")
Hi ! In Clarion 11.1.13845 easy code: System{Prop:FontSize} = 11 ! 12 Message('Text in a|few lines|with which|there was|no problem|before') gives an incorrect result Previous Clarion releases did not have this … --- ## [Notes on signing code with your own hardware (Yubikey)](https://clarionhub.com/t/notes-on-signing-code-with-your-own-hardware-yubikey/6655)
**Author:** [@CarlosGtrz](https://clarionhub.com/u/CarlosGtrz)\ **Replies:** 12\ **Last updated:** [October 15, 2023, 5:37pm UTC](https://clarionhub.com/t/notes-on-signing-code-with-your-own-hardware-yubikey/6655 "2023-10-15T17:37:11Z")
I missed the opportunity to get a non-hardware-based code signing certificate last May. Here are some notes of the process to get a new one. First option is to get it through Lindersoft. Cost is US$681 for the 3 years… --- ## [Generated SQL Update Statement for ABC Form MAY Update Multiple Records](https://clarionhub.com/t/generated-sql-update-statement-for-abc-form-may-update-multiple-records/7122)
**Author:** [@totalhip](https://clarionhub.com/u/totalhip)\ **Replies:** 18\ **Last updated:** [April 25, 2024, 12:41pm UTC](https://clarionhub.com/t/generated-sql-update-statement-for-abc-form-may-update-multiple-records/7122 "2024-04-25T12:41:02Z")
This has been reported as a bug. I post here as a caution for PG users. A simple situation -- a) Typical parent, child relationship in Dct b) Child table has a PKey on a backend sequence (ChildID). c) Child PKey is m… --- ## [When in Doubt, empty the %temp% folder](https://clarionhub.com/t/when-in-doubt-empty-the-temp-folder/7086)
**Author:** [@Bruce](https://clarionhub.com/u/Bruce)\ **Replies:** 5\ **Last updated:** [April 13, 2024, 11:26pm UTC](https://clarionhub.com/t/when-in-doubt-empty-the-temp-folder/7086 "2024-04-13T23:26:49Z")
In the Clarion Connect webinar yesterday, Kurt had a problem with reports, specifically the speed of the report editor going really slow. Peter suggested cleaning out the %temp% folder. Cunningly, that fixed the problem. … --- ## [7zip is a cheap DLL deconstructor](https://clarionhub.com/t/7zip-is-a-cheap-dll-deconstructor/7062)
**Author:** [@jslarve](https://clarionhub.com/u/jslarve)\ **Replies:** 3\ **Last updated:** [March 27, 2024, 9:52pm UTC](https://clarionhub.com/t/7zip-is-a-cheap-dll-deconstructor/7062 "2024-03-27T21:52:45Z")
Accidentally discovered that if you double click on a DLL within 7zip, you get a cheap version of a PE Explorer. You can get at the resources, certificate, and whatever else you can get to :slight\_smile: It doesn't h… --- ## [Debugging Templates with Debugview](https://clarionhub.com/t/debugging-templates-with-debugview/5085)
**Author:** [@anon23294430](https://clarionhub.com/u/anon23294430)\ **Replies:** 8\ **Last updated:** [March 27, 2024, 5:06pm UTC](https://clarionhub.com/t/debugging-templates-with-debugview/5085 "2024-03-27T17:06:38Z")
This works in C11, havent tried in any other earlier versions of the C7+ 32bit ide, but adding this to template code makes it possible to send messages to debugview without much effort so its another way to debug templat… --- ## [Driver trace (logging) to DebugView using PROP:Profile='Debug:'](https://clarionhub.com/t/driver-trace-logging-to-debugview-using-prop-profile-debug/7013)
**Author:** [@mriffey](https://clarionhub.com/u/mriffey)\ **Replies:** 9\ **Last updated:** [February 28, 2024, 10:57pm UTC](https://clarionhub.com/t/driver-trace-logging-to-debugview-using-prop-profile-debug/7013 "2024-02-28T22:57:27Z")
The Skype group gets this question regularly. Everything in this post is documented in the clarion help. Search for "driver i/o" or "logging" and you'll find it. This code shows how to enable and disable Clarion driver … --- ## [Bug in ODBC SQL Server and OLEDB driver on Windows server 2016 when connecting to SQL Server 2019 running on Windows Server 2022 Error 772 or 18 SSL Security Error](https://clarionhub.com/t/bug-in-odbc-sql-server-and-oledb-driver-on-windows-server-2016-when-connecting-to-sql-server-2019-running-on-windows-server-2022-error-772-or-18-ssl-security-error/7008)
**Author:** [@Bruce](https://clarionhub.com/u/Bruce)\ **Replies:** 4\ **Last updated:** [February 26, 2024, 8:14pm UTC](https://clarionhub.com/t/bug-in-odbc-sql-server-and-oledb-driver-on-windows-server-2016-when-connecting-to-sql-server-2019-running-on-windows-server-2022-error-772-or-18-ssl-security-error/7008 "2024-02-26T20:14:41Z")
We recently had a client who upgraded some SQL Server machines to SQL Server 2018 running on Windows Server 2022. He has a number of other Windows Server machines running our application which connects to that server. W… --- ## [Installing Clarion 11 for Windows 10](https://clarionhub.com/t/installing-clarion-11-for-windows-10/3564)
**Author:** [@DonnEdwards](https://clarionhub.com/u/DonnEdwards)\ **Replies:** 9\ **Last updated:** [February 22, 2024, 3:56pm UTC](https://clarionhub.com/t/installing-clarion-11-for-windows-10/3564 "2024-02-22T15:56:07Z")
I have started writing blog posts about Clarion, as I learn. Here is my first one: I would appreciate any comments or feedback you may have, either here or in the blog comments. I will gladly fix any errors you may sp… --- ## [VBA and Function Pointers](https://clarionhub.com/t/vba-and-function-pointers/6790)
**Author:** [@anon51095673](https://clarionhub.com/u/anon51095673)\ **Replies:** 2\ **Last updated:** [November 20, 2023, 9:49pm UTC](https://clarionhub.com/t/vba-and-function-pointers/6790 "2023-11-20T21:49:45Z")
For those with Clarion 11 and its new function pointer support this article might be of interest if you are working with MS Office VBA and want to do fancy things like send back row and column values via a function point… --- ## [REMOVE(file) vs. ds\_DeleteFile(file) == 22 seconds vs. 2 seconds on RDP!](https://clarionhub.com/t/remove-file-vs-ds-deletefile-file-22-seconds-vs-2-seconds-on-rdp/6709)
**Author:** [@RichCPT](https://clarionhub.com/u/RichCPT)\ **Replies:** 7\ **Last updated:** [October 21, 2023, 9:06pm UTC](https://clarionhub.com/t/remove-file-vs-ds-deletefile-file-22-seconds-vs-2-seconds-on-rdp/6709 "2023-10-21T21:06:49Z")
FYI: Running my C11 program on an RDP session in an Azure production server, I found that deleting one client-side file, on a redirected drive, was taking 22 seconds! After replacing the REMOVE(filename) with ds\_Delete… --- ## [Omit Cannot be nested - work around](https://clarionhub.com/t/omit-cannot-be-nested-work-around/6453)
**Author:** [@MarkGoldberg](https://clarionhub.com/u/MarkGoldberg)\ **Replies:** 3\ **Last updated:** [October 19, 2023, 12:02am UTC](https://clarionhub.com/t/omit-cannot-be-nested-work-around/6453 "2023-10-19T00:02:46Z")
Most of the time when I want to nest conditional OMITs and/or COMPILES it works as desired. However sometimes the compiler complains about it. Note: you do have to be careful to make sure that the 1st argument (the ter… --- ## [Microsoft SQL (MsSql) has Issues with BLOBs when Driver TRACE is Turned ON](https://clarionhub.com/t/microsoft-sql-mssql-has-issues-with-blobs-when-driver-trace-is-turned-on/6512)
**Author:** [@Bruce](https://clarionhub.com/u/Bruce)\ **Replies:** 5\ **Last updated:** [August 17, 2023, 9:33pm UTC](https://clarionhub.com/t/microsoft-sql-mssql-has-issues-with-blobs-when-driver-trace-is-turned-on/6512 "2023-08-17T21:33:09Z")
So this is unexpected enough that I thought I'd post here in case others run into the same issue. I've been using build 13815 (Clarion 11.1). Between MyTable and Secwin 7, I've been doing a lot of work with Blobs. Blobs… [Previous page](https://clarionhub.com/c/questions/tips/21.md) [Next page](https://clarionhub.com/c/questions/tips/21.md?page=2)