Hello Markus,

Thanks for your help.

Both errors solved with your tip.

But I am curious can't we use computed by in Stored Procedures

Regards,

Muthu


--- In firebird-support@yahoogroups.com, Markus Ostenried
<chef_007@g...> wrote:

> At 19:30 Monday, 19.04.2004 +0000, Muthu Annamalai wrote:
> >I wrote a stored procedure and it was working good, after a while

I

> >need to change three output parameters using computed by method,

but

> >I am getting error on computed by line.
>
> use this syntax:
> FULLDESCRIPTION = DESCRIPTION || ATTRIBUTE1 || ATTRIBUTE2;
>
> > I am using IB Expert to
> >write Stored Procedure. Below I produce my Stored Procedure. Apart
> >from this computed by error, my stored procedure returns four rows
> >when there is three rows in the table, I am not able to solve that
> >also
>
> and try it without the last "suspend" (you have written "suspend"

two times).

>
> HTH,
> Markus