Hi there,

I'm looking for the correct syntax to set a field in a trigger to a
value retrieved from a
stored procedure.

Here's a simplified examle (I'm not doing multiplication, but some other, more
complex calculations):

create procedure multiply(a integer, b integer) returns(c integer) as
begin
c = :a*:b;
end^

create trigger test_trigger for test active before insert as
begin
new.field = multiply(10,20); /* I'm looking for the correct syntax
to do this */
end^

Regards,
Daniel Albuschat

--
eat(this); // delicious suicide