Yes. I ran rfunc6.sql and I can do a "show" on the function:

Show function ord;

Returns

Function ORD:
Function library is rfunc
Entry point is fn_ord
Returns BY VALUE SMALLINT
Argument 1: CSTRING(1) CHARACTER SET NONE

I have taken the database from a working system and copied it to the
nonworking system and it does not work. So it is clearly (at least to me)
something in the environment of the nonworking system. I have the same
database file and firebird_1_5 directory contents (having copied both from a
good system) and it fails.

Thanks,

Aaron


Message: 23
Date: Fri, 29 Apr 2005 16:08:40 -0500
From: Mitchell Peek <mpeek@...>
Subject: Re: UDF Not working properly

is the function defined within the DB you are trying to use it?

select *
from rdb$functions
where rdb$function_name='ORD'

does that return a row?

Aaron Abend wrote:

>I created an installer for Firebird Superserver. Everything works except

for

>the rfunc.dll functions. The server seems to know the dll is in place

(since

>removing it causes a different error). But when a function in the dll is
>called I get this message:
>
>"invalid request BLR at offset 101 function ORD is not defined"
>
>ORD is the function I am trying to use.
>
>If I install Firebird from the standard installer, everything runs fine. I
>cannot find any differences in the files, configuration files, or path
>variables, and I have checked through the registry - both the working and
>non working versions look identical.
>
>What else should I be looking for?
>
>Thanks,
>
>Aaron Abend
>
>
>