--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...>
wrote:

>
> 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
>

That worked (after I changed "from RDB$FUNCTIONS" to "from
RDB$FUNCTIONS f")! Thanks Milan!