Re: SQL question
Dale E. Reed Jr. ( (no email) )
Fri, 02 May 1997 16:10:03 -0700
Marc Elbirt wrote:
> Can I use a trigger to filter inserts to a table?
> I want to tell SQL not to insert a new record into a table if it meets
> certain conditions. However, all other records should be inserted. This
> must be done server-side. Would something other than a trigger do the trick?
Yes. You can use a trigger to roll-back the transaction and erorr the
insert. I used one a while back to stop RadiusNT from inserting
Start records into the calls table.
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com