Questions tagged [clarion]

Clarion is a commercial, 4GL, programming language and Integrated Development Environment from SoftVelocity used to program database applications.

Clarion is a Programming Language and Software Development Environment developed and maintained by SoftVelocity. It has it's roots in a DOS product created in the mid-80s, which was moved to Windows by the same team responsible for Turbo Pascal. It primarily creates compiled programs for the Windows desktop environment but has also been extended to create web applications as well.

The Clarion language is similar to BASIC and Pascal in terms of syntax, but also includes support for Classes and Objects. It contains a number of unique high-level constructions including native support for window and report structures, and a backend-independent set of functions for data access. It is an easy language to learn and is quickly assimilated by programmers trained in other languages.

By treating Windows, Reports and Data as first-class elements of the language, it is particularly strong in business programs, which mostly deal with the collection, storage and presentation of data. It can interface to a variety of ISAM file formats (Btrieve, dBase, TopSpeed etc) as well as many SQL databases (MsSql, Oracle, Sybase, MySQL, PostgreSQL and so on.)

In addition to a business-orientated language Clarion includes a development environment that allows for very rapid code generation for common programming tasks. Because generated code can be mixed easily with hand-written code and because the generated code can be regenerated without losing the hand-code additions, Clarion takes full advantage of the benefits of code generation without many of the drawbacks associated with it.

The code generation layer makes use of Templates, and these templates can be created, extended and modified by developers. Thus every part of the system is under the control of the developer and every part can be changed and optimized as required. Indeed the way the whole environment is constructed allows for both radical customization and forward-compatibility at the same time.

Official Website - SoftVelocity

67 questions
1
vote
2 answers

Clarion Topspeed database scanner Mass update

I need to update a column in a Clarion Topspeed (TPS) file based on the value in another column update table set subnumber = 20 where reference1='DC'. The Topspeed Database Scanner has a Mass Update function on the File menu, but I cannot get…
lienn
  • 112
  • 7
1
vote
1 answer

C# integration in Clarion with OLE and COM dll

I've written a small test COM dll in c# and registered it. I would like to call this from Clarion. So far in clarion I have the following code ?OLE{PROP:Create} = 'test.test_COM' oc:MicData = ?OLE{ 'SayHello("myname")' } The problem I'm having is…
Thomas Snyman
  • 11
  • 1
  • 4
1
vote
1 answer

Using the devExpress WinForms controls with Clarion NET

How seamless is the integration of devexpress winforms controls in Clarion NET? Does it work at all? Is it comfortable?
BLS
  • 41
  • 3
1
vote
4 answers

Hide cmd window from Clarion

Is there a way to hide a cmd window in Clarion 8? I run xcopy to copy files defined in fields an application so it looks something like this: Run('Xcopy '&Clip(Loc:Pathfrom)&' '&loc:Pathto') i.e. Run(' C:\Temp\Temp.tps c:\Bakup\'). Maybe there is a…
1
vote
1 answer

Remove unknown hidden characters from string

I have an application (written in Clarion) that accepts user input and that input gets saved to a sql database. Then those records get processed and sent to a server via web service (written in C#). But sometimes the web service gives a bad request…
Deon
  • 203
  • 2
  • 4
  • 15
1
vote
1 answer

Conditionally set OLE definition

In Clarion, I'm looking to set the definition for an OLE dynamically in a window. Right now, this is how I define two OLE objects in a window: Window WINDOW('Test ActiveX Window'), AT(,,431,92), FONT('MS Sans Serif', 8,, FONT:regular),…
DanM7
  • 2,203
  • 3
  • 28
  • 46
1
vote
1 answer

Programmatically set button text

How do you programmatically set the button text in Clarion? Obviously I can use the designer interface to set the default text on a control, but I want to be able to change the display text in the code. Is there a way to do that? I've tried things…
DanM7
  • 2,203
  • 3
  • 28
  • 46
1
vote
1 answer

Is it possible for Clarion to load a web page within a Clarion window?

I've been asked to investigate if it is possible for Clarion 5 to load a web page within a Clarion window, not in a separate web browser. I've already tried using an OLE control and hyperlink from CapeSoft, and these work opening in a new web…
Eliana
  • 171
  • 2
  • 3
  • 13
1
vote
2 answers

Clarion 9 Windows mobile/Web development

Hi i have 2 questions: I am currently learning clarion for a project that i need to do. Currently i am looking into scanners and clarion as the language for a windows mobile application. The first issue i have is regarding the use of clarion with…
1
vote
1 answer

Field not found: SETFILTER

I am currently getting the Clarion 6.3 error: Field not found: SETFILTER The code is located in the ApplyFilter section which is part of the ObjectABC template code below: If g:InstallerIsRegional = 1 localVar:ItemCode = IWIE:InvItemCode !Store…
gazma
  • 89
  • 7
1
vote
2 answers

How to handle network connectivity issues in Clarion?

This isn't about "network programming" per say, but about how to handle the issue that arises when a client is running an application located on a server and the network connection goes down temporarily. My background is in .Net. And my…
BVernon
  • 3,205
  • 5
  • 28
  • 64
1
vote
1 answer

Write bitmap to HWND (Clarion passes HWND to .NET DLL)?

I'm writing an .NET DLL for a Clarion (Clarion is a C++ type language) program. The Clarion program calls a .NET DLL method passing to it the HWND of a Clarion image control. In the .NET DLL I can get the correct RECT (Top, Right, Bottom, Left)…
RFM
  • 93
  • 7
1
vote
1 answer

Does exception handling in Clarion exist?

Does Clarion 8 offer anything for exception handling? I know as of Clarion 5 there was no support for things like try / catch but that was released almost 10 years ago. I can't seem to find any info on how to recover from exceptions in C6 to C8…
DanM7
  • 2,203
  • 3
  • 28
  • 46
1
vote
5 answers

Sourcecontrol for Clarion 6

We're still developing a bunch of our application in Clarion 6 Enterprise. I was wondering if anyone knows of a sourcecontrol system that works well with Clarion 6?
Sorskoot
  • 10,190
  • 6
  • 55
  • 98
1
vote
1 answer

CLARION DATABASES

I have a very old aplication made in Clarion. I need to access the data externally by using the ODBC driver. The problem is that the data is stored in .DAT and .K0 files. As far as I know the data needs to be store in .TPS files in order to use de…
pochimen
  • 287
  • 3
  • 15