interbase/fire-bird recplace or update?

[Andislack]

hi!

i´ve an interbase db from an prog. called GDI (auftrag und warenwirtschaft).
in this db there is stored a path from pictures and theire endings (.jpg, .bmp etc.)

now i´ve to change the path and i´ve to put all endings in .jpg

how is this possible?
is there any possibility to "replace or update" ?

thx for your help

Andislack

 

[MartijnTonies]

Hi,

You can use an UDF and do some kind of search/replace with that.

I'm pretty sure the FreeUDFLib (google that one) has a StrReplace function.
Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird

http://www.upscene.com

 

[Andislack]

Hi Martin!

Thank you for the answer.
you were right with the udf. i found one here:

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_udf_libs

there is the rfunc (the last on the page) whith an strreplace in it.
but now i´ve another problem...
how do i use this funktion?
i compiled it like the readme-file in it and copied it into the UDF directory, but how do i work with tihs function?

thanks andi

 

[MartijnTonies]

Did you DECLARE it in your database?

Check the zip for files ending on .sql or .dll and check the readme...

Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird

http://www.upscene.com

 

[Andislack]

hi!

no i didn´t declare it to my db because i don´t know how

there is a directory called sql and there is a file called rfunc6.sql
i edited this file and put the path to connect in.
and now?
how do i declare it to my db?

thanks andi

 

[MartijnTonies]

Read the Language Reference for InterBase and check DECLARE FUNCTION. This makes a function available.

I don't know if "rfunc6.sql" is the right one. Be sure to read the readme stuff in the zip.

Somewhere, there should a part in the script that says DECLARE FUNCTION yourfunctioname ... and then some.

Do a little searching yourself.
Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird

http://www.upscene.com