Sterling Data

05/01/2026

I’ve got 3 Clarion books for sale. All are available on Ebay who will send them to the US and other countries. They are all in very good condition:

Programming in Clarion's ABC
https://ebay.us/m/aIr3Se

Clarion Tips & Techniques David Harms
https://ebay.us/m/hie0lt

Programming Objects in Clarion
https://ebay.us/m/kcuZVm

Mike

26/09/2025

While Clarion is primarily designed for relational databases, it can work with NoSQL databases through third-party ODBC drivers and API integrations. Developers can connect Clarion applications to popular NoSQL databases like MongoDB and CouchDB by utilizing REST APIs or ...

23/09/2025

Database migration in Clarion involves exporting data from the existing system and importing it into the new environment. This can be done using Clarion’s dictionary tools to define ...

20/09/2025

Database backups in Clarion can be done using built-in tools, external SQL backup commands, or by exporting data to backup files such as CSV or XML. For TPS databases, Clarion provides utilities to copy and archive data files manually or through automated scripts.

17/09/2025

Updating a Clarion application starts by identifying the necessary changes, such as new features, bug fixes, or performance improvements. Begin by modifying the Clarion dictionary if database structure changes are needed. Update the relevant procedures, forms, and reports in the application. Clarion’s template-driven approach can help automate updates for standard components...

13/09/2025

To troubleshoot performance issues in Clarion, start by analyzing the most common bottlenecks, such as database queries, file I/O operations, and inefficient loops in the code. Use Clarion's built-in profiling tools or third-party performance monitors to identify slow processes.

12/09/2025

How do I maintain a legacy Clarion application?
Maintaining a legacy Clarion application involves several key steps to ensure stability and performance. Regularly monitor the application for errors and bugs, and address issues as soon as they arise. Update the application’s data structures and business rules using...

09/09/2025

What is the Clarion dictionary?
The Clarion dictionary is the heart of any Clarion application, acting as a centralized repository that defines the structure of your database. It includes tables, fields, relationships, and business rules that govern data integrity and behavior.

06/09/2025

How do you connect Clarion to an SQL database?
Connecting Clarion to an SQL database is straightforward using the built-in ODBC or native drivers. The process typically starts by defining your database connection within the Clarion dictionary, where you specify the SQL driver and connection string details such as ...

06/08/2025

Find out why you should be using Clarion for your software...

03/07/2025

Quick, reliable bug fixing for Clarion 6 to 12 — by a developer with 30+ years of hands-on experience.

Fix the bugs that block your progress

Don't waste hours (or days) stuck in trial-and-error mode. Let me fix it quickly — and explain what went wrong if you'd like to learn.

Quick, reliable bug fixing for Clarion 6 to 12 — by a developer with 30+ years of hands-on experience.