Subject Re: [firebird-support] UDF - entry point could not be found F_ADDMONTH
Author Helen Borrie
At 07:29 AM 13/03/2011, you wrote:
>I've tried moving freeUDFlib.dll into various folders just to make sure it was in a visible path.
>I'm having trouble using a UDF in this Stored Procedure. I can see F_AddMonth in the UDF list, and the procedure compiles, but when I try to commit, I get this message:
> Invalid token.
> invalid request BLR at offset 188.
> function F_ADDMONTH is not defined.
> module name or entrypoint could not be found.
>I don't know if I should include some kind of declaration

Yes, you have to declare any UDF that you use - declarations are done *in the databases* not at server level - look up DECLARE EXTERNAL FUNCTION. Tip, some UDF libraries come with scripts that you can edit to declare just the funcs you want.