PostgreSQL - Calling Clarion Function from a PSQL Function / Trigger

[anon23294430]

@seanh

But it should be possible to create a C windows Dll that calls into a clarion one.

That will be quicker than translating the C into Clarion.

@KevinErskine if you do fancy having a go at translating it from C to Clarion

You’ll be using the C instead of typical Pascal for the calling convention,

so the
pass by value, fixed-length = someproc (Datatypes)
pass by reference, fixed-length = someproc (long) where long is the address to the datatype
pass by reference, variable-length = someproc (long) where long is the address to the datatype
or you could use *[DataType] where asterisk is the address (long) to the [DataType].

The other thing to watch out for is when you need to use RAW. Raw removes the length of strings, groups and ? (any’s).

I couldnt find any source code that refers to these C functions, only snippets at that webpage, but you have the Topspeed C & C++ compiler built into Clarion, so maybe find some small postgres source code and see if you can get that compiling in clarion.

Some of the questions you might encounter can probably be found on here, like
How can a C typedef stucture containing an array be converted to a clarion structure? - questions - ClarionHub

Linking C C++

Msbuild example for Clarion

Instead we have a hand coded project that includes a .prj with a bunch of #implib statements that creates all of the libs from all of the EXPs. That way we can do a single pass compile. – c/o @d.harms Neat idea Dave, thanks! Excerpt From “Basic Compiling and Linking” #implib #implib <libfilename> The #implib command is used to create (if necessary) a dynamic link library file. There are two forms of this command, which operate in slightly different ways. If a single filename is specified,…

Why does an ANY data type in API call StringFromGuid2() not give me a fixed GUID?

You would certain know more than I would on what happens in the compiled code. I agree with what you said. An External Function works with or without the DLL(1). I’m asking is with DLL(1) better? My understanding is DLL(1) is like Microsoft __declspec(dllimport). Is Clarion DLL(1) different? A number of web sources say it is best to specify dllimport / DLL(1) on External Functions then the Compiler can write the best code. Without DLL(1) the Linker has to fix it by adding a thunk stub which m…

You’ll just have to hunt around a bit, but I’d start with finding the postgres source code you want to compile or translate, or better still see if they have supplied any dll’s that you want to use, and then just make a lib file using the libmaker and then define some api’s in your code.