db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: Help with Triggers
Date Mon, 07 Jun 2010 16:04:09 GMT
pb2208 <pete.beatty@gmail.com> writes:

> I am trying to learn the proper way to implement triggers. I have read
> numerous entries on the web that were supposed to work with Derby. I dought
> that, since they have different code strings and different logic.
>
> I am looking at two scenarios.
> The first scenario invloves using a column trigger to sum two columns (A and
> B) and place the result in a thrid column (C) within the same table
> (mytable). I have built the following code:

You could use Derby's generated column for this:

http://db.apache.org/derby/docs/10.6/ref/rrefsqljgenerationclause.html#rrefsqljgenerationclause

Dag

Mime
View raw message