Hi !
I have one table withe some fields like this ...sum_1,sum2...sum_12 for every month.
Inside of a trigger (before trigger) I need to get some of these for a given month-value

I=0;VAL_RESULT=0;
WHILE (I<=NEW.MONTH) DO BEGIN
VAL_RESULT=VAL_RESULT+NEW.SUM_'||I;
I=I+1;
END
EXECUTE PROCEDURE MYPROC(VAL_RESULT) ;

or i have to use EXECUTE STATEMENT and get values directly from database

Thanks a lot.





____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs

[Non-text portions of this message have been removed]