Hi,

In the employee.gdb I have LOWERS UDF metadata as

------------------------------------------------------
/* External Function declarations */

DECLARE EXTERNAL FUNCTION LOWERS
VARCHAR(256) CHARACTER SET NONE
RETURNS CSTRING(256) CHARACTER SET NONE FREE_IT
ENTRY_POINT 'fn_lower' MODULE_NAME 'ib_udf.dll';
------------------------------------------------------

and when I try

------------------------------------------------------
select LOWERS( first_name ) from employee
------------------------------------------------------

it gave the error

------------------------------------------------------
Invalid request BLR at offset 63
function LOWERS is not defined
module name or entrypoint could not be found
Statement: select LOWERS( first_name ) from employee
------------------------------------------------------

Even though it is not necessary I have added

-----------------------------------------------------------
EXTERNAL_FUNCTION_DIRECTORY "F:\Profram Files\Firebird\UDF"
-----------------------------------------------------------

to my ibconfig file. the 'ib_udf.dll' is there in

F:\Profram Files\Firebird\UDF directory.

Now what should I do ?

Ben
_________________________________________________________
There is always a better job for you at Monsterindia.com.
Go now http://monsterindia.com/rediffin/