At 12:23 PM 04-07-01 +1000, I wrote:

>CREATE PROCEDURE ROUND_NORMAL
>RETURNS(B DOUBLE PRECISION)
>AS
>BEGIN
> FOR SELECT BETRAG
> FROM BETRAEGE
> INTO :B
> DO BEGIN
> B=(B/100+0.5)*100;
> END
> /* EXIT; */
> END

...assuming that, while cycling through the entire table and massaging the value of BETRAG for every row, somewhere inside that FOR loop you are going to do something with B?

H.

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________