Subject Re: [firebird-support] FB 2.1.1 delete udf
Author Dmitry Yemanov
yartax1 wrote:
>
> Few days ago, I changed server from 1.5 to 2.1.1 and restore all
> databases used. All runs ok, but now I must use the round() function
> and doesn't works. I thinks it is because I restores all UDF and there
> is the same function as internal round() than conflicts.
>
> I want to delete the udf with DROP EXTERNAL FUNCTION ROUND but I got
> the error message:
>
> Dynamic SQL Error.
> SQL error code = -104.
> Token unknown - line 1, char 24.
> ROUND.
>
>
> How about to resolve this problem?

If your database is in Dialect 3, then try:

DROP EXTERNAL FUNCTION "ROUND"

instead.


Dmitry