Subject Re: [ib-support] Re: computed by (select) ?
Author Douglas Tosi
""alex_vnru"" <ded@...> escreveu na mensagem
news:a1khvq+g19m@......
> --- In ib-support@y..., "Douglas Tosi" <douglasht@i...> wrote:
> > I read somewhere that it is possible to write a field such as:
> > FIELD1 COMPUTED BY (SELECT PARAM_OUT FROM MYPROC)
>
> Hi, All. Regardless of syntax correctness, I must warn that
> I recall some discussions where it was said that database with stored
> procedures in expressions for computed columns would be unrestorable
> because gbak restores tables before procedures. I'm not shure about
> UDFs (I don't use computed columns, it just recollection).

thanks ded,

UDFs work fine. I've been using them in computed columns for about three
years.
I tested backing up and restoring a db with a stored proc as part of a
computed column using gbak and everything worked fine.

Does anyone know the status of this? Is it fixed? Is there some special case
that makes this happens?

dog