""R. S. Patil"" <kpr_rspatil@...> wrote in message
news:3C78DF3E.9080906@......

>
> i was able to drop udf Definetions and Upload Linux UDF definetions
> without any problems.

Do you mean UDFs that are already used by some views, computed fields and
procedures? Same as generators in use, they can't be dropped. Too many
spoiled databases in the past. Your case just happens to be the opposite.

> The UDF names are offcourse same for example
>
> Windows Definetion -
>
> declare external function f_AddMonth
> date,
> integer
> returns
> date /* free_it */
> entry_point 'AddMonth' module_name 'FreeUDFLib.dll';
>
> Linux Definetion
>
> declare external function f_AddMonth
> date, integer
> returns date free_it
> entry_point 'add_month' module_name 'FreeUDFLibC';

update rdb$functions
set rdb$module_name = 'FreeUDFLibC'
where rdb$module_name = 'FreeUDFLib.dll';

Will have to implement the ALTER FUNCTION command in the future...

I personally don't use the DLL extension in Windows for declaring the
function's module_name.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing