AutoIt connect to Firebird .fdb

[horphi]

Hello all,

would like to know, whether i can connect with Autoit on a Firebird database.fdb?

I´ve seen some threads about firebird and the include of #include <FireBird.au3>.

In my Autoit  v3.3.14.1 this file doesn´t exist.

Does somebody have this file for me?

BR Horphi

[water]

When searching the forum (either by search function or bei using Google "site:autoitscript.com firebird") you will get a lot of hits.

[horphi]

Hi water,

i analysed these threads already. Nobody has the same problem like me.

I have no FireBird.au3 in my Include Folder. Where i can get it?

 

BR
Horphi

[horphi]

OK i find it.

 

 

FireBird.au3

Edited August 12, 2015 by horphi

[AMSPeople]

It is possible to get an example of use the UPDATE command?

If to use this code:

$r=_FireBird_ExecuteStatement($h_fbDll, 'update "vollink" set "barcode" = "test" where "codeint" = 9419')

I get an error:

If to use this code:

$r=_FireBird_ExecuteStatement($h_fbDll, 'update "vollink" set "barcode" = ''test'' where "codeint" = 9419')

I get an error:

How to write a valid request?

Edited December 21, 2015 by AMSPeople

[AMSPeople]

I find out what the trigger is activated before the update of the table. He uses the EXTRACTINT64 function, which is located in the library udfdll.dll. Now the question. You can somehow use the library for the correct execution of the request?