I use this 'trick' a lot (with stored procedures and triggers), and
there is no problem after a backup/restore. The triggers and
procedures still works after that.

--- In firebird-support@yahoogroups.com, "Carlos H. Cantu"
<listas@w...> wrote:

> ABS> This works,
>
> ABS> But AFAIK the BLR code could be reverse-engineered (and I

think it's not

> ABS> too dificult)
>
> ABS> see you !
>
> And remember that when you do a backup/restore all your stored
> procedures are gone since there is no source code to recreate them!
>
> Carlos
> http://www.warmboot.com.br
> FireBase - http://www.FireBase.com.br
>
> ABS> Myles Wakeham wrote:
>
> >>>On 12-May-2004 14:49:24, Salim Naufal wrote:
> >>>I have tried the following,
> >>>
> >>>Update rdb$procedures set rdb$procedure_source = ''
> >>>
> >>>It deleted the source text of the procedure leaving the BLR.

The procedure

> >>>still works fine.
> >>>
> >>>Before doing that, it would be wise to have that stuff

validated by one of

> >>>the list gurus.