kittikira wrote:

> I use Firebird 2.1.3.18185
>>> 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?

I had a similar problem. Firebird version is not that important, ODS
version is. For example, I have two databases of the same logical
structure (SQL), but different on-disk structure (ODS). IIRC, on ODS
11.1 database the computed-field dependency was detected, and on 11.0
and below it was not (of something like that).

Check ODS version with gstat -h. If it is lower than 11.1, do a backup
and subsequent restore.

HTH

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================