Re: first trigger, how do I incremement a value?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 03 Mar 2001 23:09:54 -0800
Message-ID: <3AA1EA42.120314A9@exesolutions.com>

> It's my first trigger and I need a little help.
>
> I have to Create a trigger on the HOLDING table that will add 1 to the
> appropriate value in NMBRHOLDINGS when a row is inserted into the HOLDING
> table.
>
> But I don't know how to go about actually adding 1.
>
> All I have seen or can find is comparrisons, nothing with a +,
>
> can someone help me out or post a url that can help?

Field := Field + 1;

But why not just increment a sequence? It is far more efficient.

Daniel A. Morgan Received on Sun Mar 04 2001 - 01:09:54 CST