> I'm trying to use ABS function imported by ib_udf.dll and INVL imported by
> fbudf.dll but in both case I get the following error message:

You do not need neither of those UDFs.
Instead of INVL() use COALESCE function (which is sql standard),
ABS() can be easily replaced by CASE expression.

Ivan

----- Original Message -----
From: "Diego Novati" <diego.novati@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, May 02, 2004 4:25 PM
Subject: [firebird-support] Firebird embedded & UDF


> Hi,
>
> some days ago I posted a message about Embedded Firebird and UDF but nobody answered me.
>
> Is this the right forum about Firebird Embedded ? I need an help ASAP, because I need to deploy an
application and I'd like to use embedded.
>
> Thanks
>
> Diego Novati
>
> ----- Original Message -----
> From: Diego Novati
> To: firebird-support@yahoogroups.com
> Sent: Saturday, April 24, 2004 3:24 PM
> Subject: [firebird-support] Firebird embedded & UDF
>
>
> Hi,
>
> I'm trying to use ABS function imported by ib_udf.dll and INVL imported by
> fbudf.dll but in both case I get the following error message:
>
> "Unsuccesful execution caused by a system error that precludes execution of
> subsequent statements. Access to UDF library "ib_udf.DLL" is denied by
> server administrator. "
>
> I'm using Firebird 1.5.0.4290 Embedded for Windows
>
> I updated firebird.conf file setting the options:
>
> UdfAccess = Full
>
> or
>
> UdfAccess = Restrict UDF
>
> or
>
> RootDirectory = c:\Firebird-1.5.0.4290_embed_win32
> UdfAccess = Restrict ./UDF
>
> but none of them work.
>
> Any suggestion ?
>
>
> Thanks