Hi!

is this possible? If not, how can I execute a sequence of UPDATE statements
that use parameters?

Thanks.

Tobias

P.S.: Or is there a more elegant way than this to round *down* floats to
full integer values? I am subtracting 0.5 first because the CAST adds 0.5
for the normal rounding which I don't want.

UPDATE BETRAEGE
SET Betrag=CAST((Betrag-0.5) AS INTEGER)
WHERE TYP=:STyp AND DATUM=:SDatum AND BETRAG>0;

UPDATE BETRAEGE
SET Betrag=CAST((Betrag+0.5) AS INTEGER)
WHERE TYP=:STyp AND DATUM=:SDatum AND BETRAG<0;