i've the message with a simple Select statement :

----------------------------------------
SQL> select first 10 thedate from booking;

THEDATE
=========================

2001-07-20 00:00:00.0000
2001-07-21 00:00:00.0000
2001-07-22 00:00:00.0000
2001-07-23 00:00:00.0000
2001-07-24 00:00:00.0000
2001-07-25 00:00:00.0000
2001-07-26 00:00:00.0000
2001-07-27 00:00:00.0000
2001-07-28 00:00:00.0000
2001-07-29 00:00:00.0000

SQL> select first 10 weekofyear(thedate) from booking;
Statement failed, SQLCODE = -104

invalid request BLR at offset 68
-function WEEKOFYEAR is not defined
-module name or entrypoint could not be found
SQL> select weekofyear(thedate) from booking;
Statement failed, SQLCODE = -104

invalid request BLR at offset 60
-function WEEKOFYEAR is not defined
-module name or entrypoint could not be found
SQL>
----------------------------------------

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 12:35 PM 21/06/2005 +0000, you wrote:
> >hi helen,
> >that don't work :(
> >
> >The dskudf.dll is in the correct directory location (udf in
firebird
> >installation directory), and the function work with an other DB in
> >the same server.
> >
> >virux
> >
> >--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> > > At 12:14 PM 21/06/2005 +0000, you wrote:
> > >
> > > >---------------------
> > > >invalid request BLR at offset 60
> > > >function WEEKOFYEAR is not definited
> > > >module name or entypoint could not be found
> > > >---------------------
>
> OK...this message seems to suggest that the exception is occurring
in a
> stored procedure, trigger or view. Capture the source code of the
object
> into a text file and then drop, commit, recreate and commit the
object.
>
> Also test the function in isql or ib_sql with a regular DSQL
> statement. That will indicate whether you are perhaps looking at a
> spelling error.
>
> Helen