Bogusław Brandys wrote:

> 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

Bug report:
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=429594&group_id=9028

Is it really still open (for 1.5.2 RC3) ? How about Firebird 1.0.3 and
this bug ?


Regards
Boguslaw Brandys

>
> 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
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>