Re: Before update trigger question

From: Mark Framness <framnesso_at_my-deja.com>
Date: Wed, 09 Feb 2000 19:27:20 GMT
Message-ID: <87sf2f$qcb$1@nnrp1.deja.com>

In article <87n9e0$3rr$1_at_nnrp1.deja.com>, Bob <meyer_b_at_my-deja.com> wrote:
> When using a statement level, Before Update trigger, is it possible to
> have the trigger prevent the update from happening based on a certain
> condition? If so, how do I go about this?

In additon to Sybrand Bakker's excellent suggestion (which was my first thought) you could, as long as the conditions are simple ones, apply a column condition constraint.

--
From: Mark Framness
http://netnet.net/~farmer/index.html
All standard disclaimers apply anyone who say otherwise is itching for a

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 09 2000 - 13:27:20 CST