firebird udf ltrim function

Hi,

I have configured firebird.conf (i use Firebird with Windows XP) as below :
RootDirectory = E:\Program Files\FireBird\FireBird_1_5
UdfAccess = Restrict UDF
and after i have restarded my machine.
When i use the function ltrim i have that "Sql error code = -804 function unknown ltrim". My SQL auery is :

FOR
SELECT id_nat
FROM IMPORT1
INTO :id_nat_ori

DO
BEGIN
IF(cast(id_nat_ori as integer) < 99999999) THEN
BEGIN
id_nat = ltrim(:id_nat_ori);
UPDATE IMPORT1
set id_nat = :id_nat;
END
END

Thanks for help !

You must declare the external function before you can use it. Execute this sql

or the execute the ib_udf.sql file from the UDF directory to get them all.

Lutz

Thanks for your reply.
I tried to execute the ib_sql.udf ans I obtained this message :

"DEFINE FUNCTION failed - attemp to store duplicate value (...) in unique index RDB$INDEX_9"

Sorry but I begin with Firebird.
Best regards.

Magoer

The message indicates that some of the functions from ib_udf.sql are already defined in your database. You can execute
to get a list of the defined udf's. But better you choose a tool from http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_admin_tools

Lutz

--
web based Firebird and InterBase administration: http://www.ibwebadmin.net