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
1 answer

How to bind a label control to an entry control, on Swing

In Swing we use a label control to indicate the user what information is requested in -generally- the following "entry" control. This entry control can be an entry, listbox, password etc. We can inform a displayedMnemonic to instruct the user that…
Gustavo Pinsard
  • 267
  • 3
  • 10
1
vote
1 answer

How to reconfigure path to the data files in Clarion 5 IDE?

There is a problem, the system is written in Clarion 5 came from the past and now it needs to be rewrite in Java. To do this I need to deal with its current state and how it works. I'm generate the executable file via Application Generator (\*.APP->…
user1134181
0
votes
0 answers

Azure storage bus queue listener written as COM control running as service stops receiving until user logs into server

I wrote an assembly to receive messages from an Azure storage bus queue. This assembly is written as a regfree COM control. It is used in a Windows service written in language called Clarion for Windows. Windows Server is…
0
votes
0 answers

Bulk delete records from .TPS database using OBDC Topspeed driver or Topscan

How would I go about to do a bulk record delete on a .TPS database? I've been trying with the ODBC V4 Topspeed driver in C# but each time I execute the delete command the program would just start hanging or if I add code to close the db…
hellmit100
  • 101
  • 1
  • 7
0
votes
0 answers

INSERT field of type TIME

This question is for inserting data into Clarion .TPS files using the TopSpeed ODBC driver. We are using C#. I have an insert statement like this: INSERT INTO MYTAB (SOMEDATE, SOMETIME) VALUES ({d '2020-08-25'}, 1) with SOMETIME being defined as…
Be Kind To New Users
  • 9,672
  • 13
  • 78
  • 125
0
votes
1 answer

Expected lexical element not found on Softvelocity ODBC driver

I have C# program with SQL that looks like this: INSERT INTO PDRIVERP (POLICY ,DRIVERNO ,POINTRECNO ,DRIVERPOINTS ,POINTDESCRIPTION ,DATEOFVIOLATION ,ADDOPERATOR ,DATEADDED ,TIMEADDED ) VALUES ( ,0 ,1 ,37 ,2 …
Be Kind To New Users
  • 9,672
  • 13
  • 78
  • 125
0
votes
1 answer

How to erase empty string from list of strings in Clarion?

I'm a beginner at coding in Clarion and I'm coping with problem which can be described as basic. I have this code: L_COUNTER1 = 2 LOOP IF INSTRING(L_COUNTER2& ';',L_STRING,1,L_COUNTER1 = 0 THEN L_LIST[L_COUNTER2] =…
0
votes
1 answer

Clarion 6.3 DLL, *CSTRING parameter exporte function - adds an invisible parameter?

I need to negotiate a function call, from my Delphi app, into provided DLL made in Clarion 6.3. I need to pass one or two string parameters (either one functon wit htwo params or two single-params functions). We quickly settled on using 1-byte…
Arioch 'The
  • 15,799
  • 35
  • 62
0
votes
1 answer

Clarion - Procedure params missing when importing APP into solution from APV

I'm new to Clarion and working on a task moving an existing project into Git. I have used Clarion's internal tooling to export APP files to text (via Application > Export Application To Text). However, upon importing these .APV files back into…
Steverino
  • 3
  • 3
0
votes
2 answers

What Backup Library/Code Do You Use For Your Dataset (Files On Disk)?

I'm implementing Backup functionality into my new (small) app, Oldaer. I've got standalone desktop files (rather than sitting in a SQL db). Looking around, I decided on using a Clarion 3rd-Party Template that will package them into one file and then…
Stu Andrews
  • 867
  • 7
  • 13
0
votes
1 answer

Clarion 6.3 + libcurl doesn´t work

I have the Clarion 6.3 version and after to follow the instructions from homepage i can see Clarion imported the libcurl to the system. libcurl for Clarion link But after to create a window and a button, and put code above in the button source area…
Patrick
  • 21
  • 7
0
votes
1 answer

Generate Output to commandline

I have a programm thats run on commandline. I call it like: myexe.exe parameter. Now I want to output a message to my commandline (eg. success or error) I tried: return('there is an error') --> noting is displayed Halt(0,'there is an…
ratmalwer
  • 700
  • 5
  • 14
0
votes
1 answer

Clarion Database (.dat)

I am busy rewriting and redesigning a client's software for them, the software is 20 years old and was written in Clarion, I have the .dat file (2mb in size). Does anyone know how I can extract the information from the clarion database to a csv, I…
Donald Jansen
  • 1,937
  • 4
  • 22
  • 41
0
votes
1 answer

Clarion based application in WinServer 2016, frozen. Suggestions needed on tools we could use to gather more information

I have a clarion application running in Win Server 2016 talking to a sybase DB, over the past few weeks we find the application gets frozen for different users at a given time. However the user can leave the session as such and start a new one and…
0
votes
1 answer

After upgrade from Clarion 9 to Clarion 10 an error acquiring

After upgrade app from Clarion 9.1 to Clarion 10 and after first build an error acquiring. Error: Unresolved External SHGetFolderPathA in EFOCUS.obj. I include efocus.clw in solution. Efocus.clw and efocus.inc are in C10 folder. Help me please
Joxy
  • 41
  • 4