wojciech_materna wrote:

>
> Hello, (sorry, my English is.....but I'am working on it)
> I create tables with computed fields. For example in one table I
> declare field like :
> SYMB varchar(2) computed by (substr(SYMB_FULL,1,2))
>
> Everything works good till I must do backup and restore database.
> Backup is OK, then in restore, I get error that function SUBSTR is
> not existing - so table is not created, restore stops. For every
> table in which I have computed fields which uses stored procedures
> this error occurs.
> So, to make backup and restore - first I must drop every calculated
> field, next do backup, restore and finally create them back.
>
> Am I doing something wrong? Can I do it in other way? It is not good
> to use computed fields on this kind?
>
> Thanks for every comment
> Wojtek
>

Try to reproduce the same error with Firebird 1.5.2 RC3.
You didn't wrote Firebird version used , but if it is Firebird 1.5.1 or
1.5.0 then I remember that there was a bug related to this problem (UDF
function declaration is restored after computed field probably).
Maybe someone describe this in details.


Regards
Boguslaw Brandys