| Subject | Re: [firebird-support] Re: Computed By Error in Stored Procedure --Help |
|---|---|
| Author | Markus Ostenried |
| Post date | 2004-04-19T23:42:55Z |
At 22:29 Monday, 19.04.2004 +0000, Muthu Annamalai wrote:
procedure and trigger language). PSQL doesn't have a "computed by"
expression, instead assigning a value to a variable is done like in C.
"computed by" is only used when declaring a new column for a table. There
you tell Firebird that the expression following the "computed by" clause
should be used to determine the value of the column you are declaring.
HTH,
Markus
>But I am curious can't we use computed by in Stored ProceduresWhen writing stored procedures you have to use the syntax of PSQL (stored
procedure and trigger language). PSQL doesn't have a "computed by"
expression, instead assigning a value to a variable is done like in C.
"computed by" is only used when declaring a new column for a table. There
you tell Firebird that the expression following the "computed by" clause
should be used to determine the value of the column you are declaring.
HTH,
Markus