A Firebird example app

Hi,

Once again somebody asked how to setup Clarion with Firebird.
It’s very easy as the attached example will demonstrate i hope :slight_smile:
Unzip files from Firebird3_2.zip and Firebird3_3.zip in directory where Firebird3_1.zip is installed

.Firebird3_3.zip (967,5 KB)
firebird3_1.zip (2,7 MB)
firebird3_2.zip (2,9 MB)

3 Likes

Hi Dirk,
Thanks for this. It works great.

I see that in “firebird3_1.zip” you included a file called “fbclient.dll”, and on the 2nd zip you included other firebird dlls. Why did you separate the firebird related dlls like that?

Edgard

Hi Edgard,

To upload a zip the max size is 3 mb

I my apps i seperate the data from the program.

In the frame i call very early (program setup priority 1800) procedure settings()

in settings i have some code like

Settings procedure

if not exists(glo:uncDatapath)
stop(‘Data map not found!’)
end

System{prop:datapath} = glo:uncDatapath !directory for firebird files.
ds_SetUpgPath(glo:uncDatapath) !to set UPG.TPS file if you use capesoft FM3
SetPath(glo:uncDatapath) !Now the actual directory isn’t the program map but the data map


In the datapath i have

intl !map
plugins !map
ALLDATA.FDB !the firebird database file
fbclient.dll
firebird.con
firebird.log
firebird.msg
ib_uitl.dll
icudt52.dll
icudt52l.dat !important on 64 bit systems
icuin52.dll
icuuc52.dll

Set to 10 mb now, just like for images but linking to a github repo is preferable if you can.
Thanks for the contribution!! :star:

fico grato.
vc conseguiria disponibilizar para a versao 9 do clarion;

alejandre

Hi alejandre

Dirk’s example includes testfirebird.dctx and testfirebird.txa so you may be able to use those in Clarion 9 to import into an empty dictionary and application.

cheers

Geoff R

Hi,
May be it is a bit late to ask, but is it possible to have a clarion 6.3 version of these examples

with lots of thanks.

Regards