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
2
votes
2 answers

Remove all non-numeric characters from a CString

I need to format a CString that contains a phone number. I need to remove all spaces and all characters that are not a number. Please advice on how I can do this. tel1 = replace(tel1,' ','') That is how it would be done in C# but I don't have a…
Arno Botha
  • 59
  • 1
  • 6
2
votes
0 answers

Focusing Issue in Clarion 6

We have an application in Clarion 6 which does not have any mdi windows in it anywhere. These have all been removed and made non-mdi. When this one window is open and other windows are opened off of it (say from a button click), the first window…
2
votes
4 answers

Convert a Clarion Procedure Declaration to C# DLLImport

How can I convert this Clarion procedure declaration to C#? It's part of a 3rd Party DLL written in C, which doesn't have much documentation. I have listed the prototype for the method in Clarion that is working correctly. In C#, I'm not sure…
DanM7
  • 2,203
  • 3
  • 28
  • 46
1
vote
2 answers

How to extract data from a .tps topscan Clarion file?

I have to make a MySQL database from a Clarion database. The tables are .tps files. I don't know how to do it, for now I only found applications that work with .dat files.
HoNgOuRu
  • 717
  • 4
  • 13
  • 26
1
vote
1 answer

What are hidden fields in a Clarion .TPS file?

I am looking at extracting some data from a Clarion .TPS file and I have been using the TopScan Application to open them. When I look at the tables there are lots of hidden fields. Are they just protected fields i.e. to stop someone from seeing the…
Ace Grace
  • 631
  • 1
  • 7
  • 21
1
vote
1 answer

Passing parameters to SSRS from Clarion

I have a SSRS report that need 2 parameters ... I need to call it from Clarion using hyperActive template... Others reports without parameters work good but for this I'm testing the URL in IE and I got the error.. the parameters are used by stored…
user1004299
  • 135
  • 6
  • 14
1
vote
1 answer

Calling C# DLL http.client.GetAsync(uri) with await causes SEHException

I'm calling c# dll unmanaged methods from a different language. I have callback set so my app gets results thru it when c# dll is done. This causes SEHException on .Invoke: public static async Task> Fetch2(Uri uri) { …
1
vote
1 answer

PostgreSQL time intervals in Clarion

How to rewrite this query from PostgreSQL in Clarion? select extract(epoch from (timestamp '02-01-2021 06:00' - timestamp '01-01-2021 22:00'))/3600 as interval_as_hours_numeric
Matestro
  • 39
  • 4
1
vote
0 answers

I have a functionality where i can copy the tokens which has some errors

Errorcode is 05 Access Denied/48 Unable to Log Transaction, this has come from RTL, not a custom function message, and only happens sometime when tokens are being fetched from database. Everytime I trigger this function I use to get different…
Vedant
  • 11
  • 4
1
vote
2 answers

Numeric (not integer or double precision) picture token Clarion+Postgresql

i need numeric mask like this: 100 101.1 102.123 Take maksimum given decimal places but if last digit is 0 trim it. Something like: @n-12_`2 but trim right 0 and . Ex: x = 102.1230057::double precision select rtrim(rtrim(round(x::numeric, 2)::text,…
Matestro
  • 39
  • 4
1
vote
1 answer

How to print exceldocument containing multiple worksheets with shellexecute

I have a shellcommand in a application that prints a exeldocument. p1 = 'print' p2 = 'c:\mydir\myexcel.xlsx' p3 = '' p4 = '' p5 = 8 ShellExecute(GetDesktopWindow(),p1,p2,p3,p4,p5) this works fine. Now there are excel-files with more than one…
ratmalwer
  • 700
  • 5
  • 14
1
vote
4 answers

Clarion: Possible to use a C# Assembly?

Is it possible to use a C# assembly from Clarion? If not. Is it possible to run a simple console application written in C# and read the output from it back into Clarion? In both cases, how would you do it? In the case of the assembly, would you have…
Svish
  • 152,914
  • 173
  • 462
  • 620
1
vote
1 answer

Share 1 table between 2 different types of databases

The problem that I have is that I want to synchronize one table between two different databases. Database 1 is on a XP server with MySQL Database 2 is on a Novell server with Clarion. Is it possible to share one table users between the two…
Diederik
  • 11
  • 1
1
vote
2 answers

Client Decompression System ERROR! Exception code: 0xc0000005

We have a legacy windows desktop client application that calls a Load Balancer (running in Windows Server 2003) that delegates the request to an Application Server (Windows Server 2003) that connects to an SQL Server (Windows 2008 R2 Database…
Manuel Hernandez
  • 581
  • 1
  • 7
  • 11
1
vote
1 answer

RazorSQL profiles, command line calls & windows task user mixup

They might be quite obscure: i enjoy RazorSQL for all it can do, and it is the only tool i found that talks properly is Clarions's ODBC driver. It also allows for awesome command line calls to export data. Trouble is: RazorSQL stores profile…
drew..
  • 3,234
  • 3
  • 16
  • 19