ke4dm wrote:

> Thanks Helen, you put me on the right track. I had to rename the .so
> file from FreeAdhocUDF_fb2x.so to FreeAdhocUDF.so then DROP and
> re-declare the function. I guess I'll have to do the same with the
> other 404 functions...that should keep me busy for a while.

Well, you could simply drop them all using something like this:

set term !! ;
EXECUTE BLOCK RETURNS (stmt VARCHAR(1000)) AS
BEGIN
FOR
select 'drop extermal function '||f.RDB$FUNCTION_NAME||';'
from RDB$FUNCTIONS
where rdb$module_name = 'FreeAdhocUDF.so' /* or whatever */
into :stmt
DO begin suspend; execute statement :stmt; end
END!!
set term ; !!

...and then use the .sql file to declare them.

--
Milan Babuskov
http://fbexport.sourceforge.net