I just discovered the reason for the problem.

I used round in some computed fields.
Now I removed the computed fields and the the udf round and everything works fine.

Why does Firebird not tell me, that the udf is used by computed fields, when I want to drop it?
If it is used in a stored procedure, a trigger or a view I cannot drop the UDF. Why can I drop it when it is used by a computed field?

--- In firebird-support@yahoogroups.com, "kittikira" <hs@...> wrote:
>
> I have a problem, when removing an UDF.
> I have an UDF "round", that does axactly the same the internal function round does.
> So I want to remove the UDF round, to use the internal function.
>
> I removed it by
>
> drop external function round;
>
> To do so, I had to alter many stored procedures and triggers, for round was used there.
>
> Finally I could drop the external function round.
>
> Now I have a problem when making a backup. Gbak tells me, that the external function round is missing.
> The same problem when using b_line_count (an UDF that counts the lines of a text blob). "invalid request BLR at offset 6 function round not defined".
>
> I had to declare the UDF again to get it working.
>
> What could be the reason for this problem=
>