Hello,

Sean, Christian, thanks for your answers ! It gives me the solution.

I looked your solution Christian, i was very interested by desactivating the procedures, IBexpert desactivate procedures by doing an alter of them and comments the code inside.
I want to do it by script, because i have more than 1 database with the same structure to change to FB2.1.
In my script i'm not going to comment content of procedures but i'll simply make them empty (or drop them if there is no dependence), so that my script does not become huge.

After that i'll
- drop the udf
- backup in 1.5
- restore in 2.1
- and use a script to recreate/alter the procedures containing the trim functions.

...

And that works fine !

Thanks for your ideas.


Marianne

--- In firebird-support@yahoogroups.com, Christian Mereles wrote:
>
> Hello,
>
> You could also do:
>
> 1. Disable all triggers and procedures. IBExpert lets you do it all at once
> (Desactivate ALL Triggers/Store Procedures).
> 2. Delete or rename the UDF
> 2. Backup and Restore the DB.
> 3. Activate one by one and trigger procedures.
>
> Regards.
>
>
> PD: Sorry for my English :)
>
>
> [Non-text portions of this message have been removed]
>