On Wed, 2006-05-31 at 15:51 -0500, Guy Rouillier wrote:
> Charles Curi wrote:
> > Hi people!!!
> > I have a table called "orders" with fields "a","b" and "c".
> > I want to make a INSERT only of fields "a" and "b" by Java and at
> > this moment c=a*b; Is it possible?
>
> I think you are saying you want your Java code to insert fields "a" and
> "b" and have "c" automatically set to a value derived from "a" and "b".
> If so, you can accomplish this with an insert trigger.
>
Or you could just insert a, b and a*b yourself . . . . or am I missing
something here?
-- Mark