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.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com