| Subject | Re: [firebird-support] Re: Monthly Report Stored Procedure |
|---|---|
| Author | Lucas Franzen |
| Post date | 2005-12-10T10:27:15Z |
Muthu,
ELSE IF (MONTHNUM = 2) THEN FEB = AMT;
Remove the colon (:) in front of MONTHNUM.
You do just need this when used as a variable that's selected into or if
it's part of a DML statement (insert into, update).
Luc.
> Here is my new stored procedurefine.
> IF (:MONTHNUM = 1) THEN JAN = AMT;IF (MONTHNUM = 1) THEN JAN = AMT;
> ELSE IF (:MONTHNUM = 2) THEN FEB = AMT;
ELSE IF (MONTHNUM = 2) THEN FEB = AMT;
Remove the colon (:) in front of MONTHNUM.
You do just need this when used as a variable that's selected into or if
it's part of a DML statement (insert into, update).
Luc.