XProfan

E.T.

...The Datenbankdatei must itself with the Benutzung the embedded Server next to this ditto
in the Applikationsverzeichnis find. ...

is me at reading the guide over ands over again noticed. mostly lying The DB Yes in another directory...

[offtopic]...only so as thought...

[/offtopic]

Grüße aus Sachsen... Mario
WinXP, Win7 (64 Bit),Win8(.1),Win10, Win 11, Profan 6 - X4, XPSE, und 'nen schwarzes, blinkendes Dingens, wo ich das alles reinschütte...

04/17/09 ▲

Dietmar
Horn

No, Mario,

The couple DLLs can in the same directory lying, as DB, anderenfalls go tappt im dunkeln from the (umbenannten) fbclient.dll in the windows-, windows-system- or windows-system32-directory sought. the having we everything for hours in vain durchprobiert (like then The thing with the BLOBs). with ImportDLL(fbclient.dll,*) can itself very standing, where The fbclient.dll The others couple DLLs with the restlichen functions seek. if need be can Yes with ChDir into Ordner change, in the itself these couple Files bustling.

and loudly the many FB-Help Files position in the Embedded-Version The fbclient.dll for the DBMS whom actual Server dar, the any FB-Funktionalitäten pub available position - but in the Contrast to Nichtembedded-Version must the users there not first each yet so small DB-Program In the Control Panel whom ODBC-driver konfigurieren.

of my opinion to missing there (or. me) yet only yet the allererste Baustein, circa this Server (means The Embedded-FBClient.dll) To initialisieren.

I suspect or. befürchte soon, that the yet with XProfans SQLInit not so without further possible his becomes. I wealth time, here becomes probably only Roland yourself zeitnah help on can - like with the BLOB-story - or of/ one from the others API-Specialists, which now already accurate with the FB-APIs know, without itself yourself first with difficulty herantasten To must ... if need be even over a new, yet with C++ or Delphi To erstellende FB-Embedded-DLL for XProfan. my next Befürchtung goes to there, that SQL-Exec ditto whom installierten ODBC-driver voraussetzt and to the whole SQL-Zeugs with SQLEXEC then ditto api-mäßig yourself nachbasteln should. hopefully have I with my Berfürchtungen not right, because then would without Rolands rapid Help my News already right far fortgeschrittenes proposition only from this Found to that failure doomed and monatelange Programmierarbeit for Katz been.

i'd me however gigant above forward, if I in this Points fallacy begehe what about me time again only whom woods not sheer trees see. still How in the Ausgangsposting already said: The Time depends me because of this story meanwhile integrally beautiful in the neck.

Greeting
Dietmar

Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...]

Windows 95 bis Windows 7
Profan² 6.6 bis XProfan X2 mit XPSE

Das große XProfan-Lehrbuch: [...]

04/18/09 ▲

RGH

Hi,

even if I today no Time have, one first Info: without ODBC-driver becomes it naturally not weg: without ODBC-driver can The ODBC-interface of XProfan naturally not functions. gives it a ODBC-driver for Firebird-Emedded? or can itself the previous driver for Embedded konfigurieren?

Direkter appeal over The API the DLL could naturally weg. is these somewhere documents? Presumably there there a Documentation for Delphi or C++ ... or in the worst drop only finished Komponenten without Source, The over your Zugriffe nothing Price give.
(though wären The recent Überlegungen then objectively quite trashy, there it then Yes circa something integrally other goes. the had one of beginning on allude must. OK, The surface can naturally stay ...)

Greeting
Roland

Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4

Perhaps time whom Florian Heuberger ask whether it with Visual-Zeugs on something like grabbed has.

Dietmar
Horn

Hi,

No, this is Yes the sense of FB-Embedded, that one there none ODBC-driver needed. several others Programs from this Branche make the just as. The users can optional switch, whom mode it benefit would like: Embedded (local, without gleichzeitigen Mehrfachzugriff), or not-Embedded (Mehrfachzugriff on DB over networking possible).

on Documentations have I the, what with FB anyhow thereby is, the I along into the above-mentioned ZIP gepackt have and another API-Guide for Interbase (IB and FB should well compatible his) - see Appendix. for me one book with seven Siegeln!

though wären The recent Überlegungen then objectively quite trashy, there it then Yes circa something integrally other goes.

trashy not, because I need coercive both Modi. only stupid, that the Projektleiter The Beta-Version selected Testern now for the time being as Embedded give would like (because these To 99% not in the site are, the ODBC-story yourself einzurichten).

whom normalen mode have I ready, there functions dbzgl. with XProfan yet everything fine.

Greeting
Dietmar

60ApiGuide.zip	1.736 kB

Hochgeladen:	04/19/09

Downloadcounter:
		Download

Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...]

Windows 95 bis Windows 7
Profan² 6.6 bis XProfan X2 mit XPSE

Das große XProfan-Lehrbuch: [...]

RGH

Hi,

How said, for in XProfan integrierten ODBC-functions is a ODBC-driver zwingende Prerequisite.
this switch on Embedded without ODBC functions means only for Applications, The generisch, means directly by Firebird- or. Interbase-API, with the data base communicate. for Delphi or C++ go presumably suitable Komponenten included. with this Applications becomes means at the outset not the detour over ODBC gone. The Access to The data base is So one integrally another and there are The recent Überlegungen to that Save and Reading BLOBs over ODBC objectively hardly useable.

Möglicherweise need one but no extra To schreibende DLL, separate can The API directly use.

Greeting
Roland

Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4

RGH

Hi,
I have time a short look on the API-Guide thrown. there shining Yes everything drin To stand, what need:
isc_attach_database() to that Open the data base, isc_dsql_exec_immediate() to that Perform one SQL-Statements, etc.
declared reminds a little bit on The ODBC-API. I look time, I The next days Time find, so a little bit To experiment. (but it I hindere too niemanden, it self To try. The Beschreibungen shine me right in detail To his.)

Greeting
Roland

Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4

Dietmar
Horn

Hello Roland,

thanks beforehand for your trouble!

If this Embedded-mode somehow works, then be I fix and ready and will be certainly ripe for Klappse his! the would then Perhaps but neither badly, because there had I presumably sufficient Time, my XProfan-Textbook circa two further more chapter To complement:

XProfan and The relationalen Datenbanksysteme Firebird and Interbase

1. my poor nerves and Firebird
2. introduction in Firebird with XProfan

because Firebird Yes free to have is, would the then a clevere not-ODBC-alternative to the z.T. still right eingeschränkten and The years gekommenen dBase.

Greeting
Dietmar

Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...]

Windows 95 bis Windows 7
Profan² 6.6 bis XProfan X2 mit XPSE

Das große XProfan-Lehrbuch: [...]

04/20/09 ▲

RGH

Hi,

here first part to usage of direktem Access to Firebird through XProfan. the example ought to sowohl for Client-Version (there is The DLL though differently: fbclient.dll, with Interbase naturally too) as well as as here for Embedded-Version functions.

ACHTUNG: the example functions! If one with Yes answer becomes The data base objectively deleted and at attempt, The not any more available data base To close, there The entsprechene Firebird-Error Message. ALso before Please a Sicherheitskopie the Datenbankdatei (in the example Patienten.fdb) create.

what happens in the program?
- with ImportDLL go The API-functions the DLL imortiert
- with isc_expand_dpb() becomes the Verbindungsstring created. In unserem drop need we only Username and password. The suitable Konstanten come from the ibase.h
- with isc_attach_database() becomes The link to data base manufactured. If the first entry the status-Arrays a 1 is, is the second entry in the entrapment mismatched 0 The Interbase-Fehlernummer. In this case is with isc_interprete() the Text the suitable Error Message determined.
- with isc_drop_database() can we now The data base delete. the works naturally only with korrektem Usernamen and password. otherwise there a Error Message. (the Delete the data base have I as virtually Test for erfolgreiche link chosen, because one SELECT a little bit komplexer would ... ;) ) with something Fleiß and experience can naturally with the übrigen API-functions too SQL-Statements put down, BLOBs write and reading, etc. declared reminds a little bit on The ODBC-API ... unfortunately only a little bit.
- with isc_detach_database() becomes The link to data base exits ... vorrausgesetzt tappt im dunkeln watts in the vorigen step not deleted.

the example proving, what but eh clear was: If with others Programmiersprachen the direct Access to Firebird goes, goes it too with XProfan:
Compile Mark Separation

FireBird Embedded Demo
----------------------
©2009 Roland G. Hülsmann
Definitionen aus ibase.h
def &isc_dpb_user_name 28
def &isc_dpb_password 29
declare msg#
declare status_vector&[20]
declare pdpb&, pstatus&
var hdll& = ImportDLL(fbembed.dll, fb_)
dim msg#, 512
var dpb_length& = 0   Länge des Verbindungsstrings
var db1& = 0          Databasehandle
var user$ = SYSDBA
var pass$ = masterkey
var name$ = Patienten.fdb
cls
Verbindungsstring erstellen
fb_isc_expand_dpb(addr(pdpb&), addr(dpb_length&),
&isc_dpb_user_name, addr(user$),
&isc_dpb_password, addr(pass$),
0)

whileloop 0, dpb_length& - 1

    print hex$(byte(pdpb&,&loop));,;

endwhile

Verbindung zur Datenbank herstellen und auf Fehler prüfen
fb_isc_attach_database(addr(status_vector&[0]), len(name$), addr(name$), addr(db1&), dpb_length&, pdpb&)

if ((status_vector&[0] = 1) and status_vector&[1])

    pstatus& = addr(status_vector&[0])
    fb_isc_interprete(msg#, addr(pstatus&))
    messagebox(string$(msg#, 0), Firebird-Fehler, 16)
    end 1

endif

Hier könnte nun der Zugriff auf die Datenbank stattfinden ...
Im Beispiel wird die Datenbank gelöscht! (Vor dem Ausprobieren bitte Sicherheitskopie anlegen!)

if messageBox(Wollen Sie die Datenbank wirklich löschen?, Frage:, 36) = 6

    fb_isc_drop_database(addr(status_vector&[0]), addr(db1&))

    if ((status_vector&[0] = 1) and status_vector&[1])

        pstatus& = addr(status_vector&[0])
        fb_isc_interprete(msg#, addr(pstatus&))
        messagebox(string$(msg#, 0), Firebird-Fehler, 16)
        end 2

    endif

endif

Verbindung mit der Datenbank lösen und auf Fehler prüfen
fb_isc_detach_database(addr(status_vector&[0]), addr(db1&))

if ((status_vector&[0] = 1) and status_vector&[1])

    pstatus& = addr(status_vector&[0])
    fb_isc_interprete(msg#, addr(pstatus&))
    messagebox(string$(msg#, 0), Firebird-Fehler, 16)
    end 3

endif class=s4 href='./../../Function-References/XProfan/end/'>end

Greeting
Roland

Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4

04/20/09 ▲

Dietmar
Horn

Thank you!

the SQLInit and SQLDone hätten we then already time.

If I still somehow the Äquivalent To SQLEXEC by API with the integrally normalen SQL-Übergabestrings (SELECT, INTO, UPDATE, etc.) had, then would The cow Yes first time almost of ice-cream.

Greeting
Dietmar

Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...]

Windows 95 bis Windows 7
Profan² 6.6 bis XProfan X2 mit XPSE

Das große XProfan-Lehrbuch: [...]

04/20/09 ▲