Subject RE: [firebird-support] Field computed by a stored proc
Hi all,

This statement :

create table TEST (
  TEST_ID integer not null,
  NAME varchar(80),
  FIRSTNAME varchar(80),
  COMPANY varchar(80),
  FULLNAME computed by

As suggested by Adam "Compiles" (no SQL error) but the server "infinite
loops" (99% of processor used, I had to kill fbserver process.)

I will create a stored proc to compute this field at select time.


Pierre Y.

De :
[] De la part de Jason Dodson
Envoyé : vendredi 22 avril 2005 15:42
À :
Objet : Re: [firebird-support] Field computed by a stored proc

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.


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,
> first_name, company)))
> );
> Firebird refuses to compile that statement.
> Can you help me ?
> Thank you very much, regards,
> Pierre Y.

> Yahoo! Groups Links


Yahoo! Groups Links
• To visit your group on the web, go to:
• To unsubscribe from this group, send an email to:
• Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.