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
54
votes
11 answers

How to count each digit in a range of integers?

Imagine you sell those metallic digits used to number houses, locker doors, hotel rooms, etc. You need to find how many of each digit to ship when your customer needs to number doors/houses: 1 to 100 51 to 300 1 to 2,000 with zeros to the left The…
Carlos Gutiérrez
  • 13,972
  • 5
  • 37
  • 47
6
votes
1 answer

Access and modify clarion .dat file

Does anyone know how to access and edit the .dat clarion files? It seems that clarion is a database for DOS. the tables are stored in DAT files. I need to update few fields of that file.
viz12
  • 675
  • 1
  • 11
  • 20
6
votes
4 answers

CLARION Date Conversion C# + DATE ADD/SUBTRACT

*(This is for ISV database so I am kind of reverse engineering this and cannot change) ... How can I do the following date to int (visa/versa) conversion in C# ... So Say the Date is: 5/17/2012 it gets converted to int 77207 in the database. At…
bumble_bee_tuna
  • 3,533
  • 7
  • 43
  • 83
5
votes
1 answer

What does the symbol :=: mean (colon equals colon)

I've found the symbol :=: in some Clarion code and I can't seem to figure out exactly what it does. The code was written by a previous developer many years ago, so I can't ask him. I also have not been able to find any results for "colon equals…
DanM7
  • 2,203
  • 3
  • 28
  • 46
4
votes
3 answers

How do I properly pass an array address in Clarion?

Prototype: myFunction( ULONG , *ULONG ),PASCAL Variables: myArray ULONG, DIM(30) myStuff ULONG Code: ... myFunction(myStuff, myArray) ... Error: No matching prototype available - C:... Is there something wrong with the prototype itself or am…
Proxus
  • 61
  • 5
4
votes
1 answer

Convert from tps to csv

I am writing a program based on an SQL database to take the base of a Clarion 16 bit program which is soon to be non functional. However, I need to get their old records and the program does not offer much as far as export, and TopScan is like 600…
Snymax
  • 357
  • 4
  • 18
4
votes
1 answer

Calling Clarion DLL from C#

I am currently working on a at an IT company. They made their software using Clarion, and in that software they have a DLL which recalculates a lot of values from their database. I need to call this DLL from my C# project. I tried everything…
3
votes
4 answers

POSTing to the web in Clarion

I'm developing a RESTful API for a client. The problem is, he's using a rather obscure language called Clarion. It's proprietary and closed, and the docs are not freely available online. Whenever we discuss passing data from his code to mine, and…
Paul McMillan
  • 19,693
  • 9
  • 57
  • 71
3
votes
1 answer

.NET DLL needs to receive a Clarion callback procedure and then all it passing three ints?

I'm writing a C# .NET DLL for a Clarion (Clarion is C++ like programming language) program. I call into the C# .NET DLL just fine, all is working great. However, I need that C# .NET DLL to receive a Clarion Procedure for callback purposes and then…
RFM
  • 93
  • 7
2
votes
1 answer

How to access Clarion Tables from Java

I have this client with this system coded in Clarion. He is needing an webservice in Java to public some APIs from their system. Does anyone know the best approach to access and modify any given clarion table ( .dat file) ?
Garis M Suero
  • 7,974
  • 7
  • 45
  • 68
2
votes
0 answers

How to send 3 variables/arguments from batch script (.bat) to JavaScript

Can someone help me!?! So I have half a batch (.bat) half javascript script. From clarion I send 3 arguments 0: name of .bat (the batch script) 1: list of arguments 2: a name (string text) I want to know how to get my variable in batcsh and…
Joxy
  • 41
  • 4
2
votes
1 answer

GET / POST using Clarion

I have Clarion 9 app that I want to be able to communicate with HTTP servers. I come from PHP background. I have 0 idea on what to do. What I wish to be able to do: Parse JSON data and convert QUEUE data to JSON [Done] Have a global variable like…
Shafiq al-Shaar
  • 1,292
  • 14
  • 22
2
votes
1 answer

Odbc Connection to .tps database not working

I am trying to select some fields from .tps file but I am getting the following error: This is my Code: …
CodeMan
  • 133
  • 3
  • 19
2
votes
1 answer

Programmatically fire button click event

Is there a way to fire a button click event programmatically in Clarion? I've tried the following but they haven't worked: ! Doesn't work: ?ResetInput ! Also doesn't work: ?ResetInput:Accepted
DanM7
  • 2,203
  • 3
  • 28
  • 46
2
votes
1 answer

Access violation in WCF with COM object after garbage collection

I have a self-hosted WCF application where the service objects (per call, single concurrency) use embedded COM objects (referenced from the class throughout the call) built on a platform called Clarion. The COM instances are created and destroyed…
Vadim Berman
  • 1,932
  • 1
  • 20
  • 39
1
2 3 4 5