Re: Triggers
From: Maurício Bellissimo Falleiros <mbf_at_uniconsult.com.br>
Date: Mon, 04 Oct 1999 11:54:14 -0300
Message-ID: <37F8BF96.F412CA48_at_uniconsult.com.br>
Date: Mon, 04 Oct 1999 11:54:14 -0300
Message-ID: <37F8BF96.F412CA48_at_uniconsult.com.br>
Hi,
it seems to me there has been some misunderstanding here. Correct me if I am wrong.
If you want to update one column as a function of two others in the same
record,
you should use only a "before insert or update for each row" trigger,
with the code:
...
:new.z3 := :new.z1 * :new.z2;
...
Just that...
Maurício.
-- Maurício Bellissimo Falleiros <mailto:mbf_at_uniconsult.com.br> Uniconsult Sistemas e Serviços <mailto:uss_at_uniconsult.com.br> R. Demóstenes, 627 cj.134/142 - Campo Belo - São Paulo/SP - 04614-013 Brasil Fone/Fax: +55-11-5350885 +55-11-5333335 "Em um minuto apenas há tempo Para decisões e revisões que um minuto revoga." T.S.Eliot * Sent from RemarQ http://www.remarq.com * The Internet's Discussion Network * * The fastest and easiest way to search and participate in Usenet - Free! *Received on Mon Oct 04 1999 - 16:54:14 CEST