At 08:02 AM 18/10/2003 +0000, you wrote:

>Iam sorry ... but iam getting this error after I execute this one...
>
>select "ItemID", f_weekofyear(cast("ProduceDate" as date)), sum
>("Qty") as "Qty"
>from "produce" m
>where "ProduceDate" >= '9/1/2003'
>group by f_weekofyear(cast("ProduceDate" as date))
>
>
>Invalid token.
>invalid request BLR at offset 96.
>function F_WEEKOFYEAR is not defined.
>module name or entrypoint could not be found.

That means the server can't find the library.
1. Did you declare the function to the database?
2. Did you put it in a place where the server knows to look for UDF libraries?

hb

>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/