At 06:47 PM 30-10-02 -0600, you wrote:

>Hi,
>
>I'm working with an application that was written in IB v5.x. The ddl
>references an external library FreeUDFLib.dll and several functions
>reference that library. This causes error when trying to do simple sql on
>several tables, like:
>
> SQL> select * from atable ;
> Statement failed, SQLCODE = -104
>
> invalid request BLR at offset 2
> -function F_DEFAULTFLOAT is not defined
> -module name or entrypoint could not be found
> SQL>
>
>So....
>
>1) Will FreeUDFLib.dll work with Firebird? If yes, where can I get it?

Yes, it will certainly work with Firebird running on a Windows server and
some functions *might* work with Firebird running on a Linux server. The
original FreeUDFLib was written in Delphi by Greg Deatz and fixed up by
Claudio Valderrama for IB 6. Someone did a C version of it for Linux some
time ago and it appears from reports that the Date and Time functions were
not brought up to date with the Dialect 3 changes to the date types.

You can pick them up from
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_contrib_download#UDF

You need to place them in the ./udf sub-directory of your Firebird
installation. In Firebird you can alternatively place them in your own
custom path on the server. Ask again if you need to know how to configure
this.

>2) Better yet, can I somehow disable the need for the external library and
>still access all the data?

If you have SQL statements in client programs or in server modules (such as
stored procedures or triggers) that use these functions, then you need the
external library. If you decide to make a design decision to avoid
external function libraries altogether, then your only option will be to
substitute client-side code to perform the same work on the raw data.

regards,
heLen