For a computed field, you are more or less restricted to using the
fields in the current record, any results from a UDF function, and/or
any evaluations contained there of.

In short, I don't believe you can use a recordset in a computed field.
Honestly, thinking about it, most cases, the performance of such a
method would be ... not good.

Jason

zedalaye@... wrote:

> Hi,
>
> How can I create a field computed by a stored proc ?
>
> Create table test (
> Test_id Integer not null,
> Name VarChar(80),
> FirstName VarChar(80),
> Company VarChar(80),
> FullName computed by ((select fullname from sp_get_fullname(test_id, name,
> first_name, company)))
> );
>
> Firebird refuses to compile that statement.
>
> Can you help me ?
>
> Thank you very much, regards,
>
> Pierre Y.
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>