×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.



  1.  Home
  2. MIDRANGE-L
  3. April 2015

Re: Is there a way to add a Where clause to an SQL After Insert Trigger?

Hi Jeff,

You cannot specify criteria for an insert trigger.
The logic would have to be placed within the trigger program itself.

Hope this helps.

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (416) 675-9200 ext. 89224
Cell: (416) 317-3144




On 30 April 2015 at 15:30, Jeff Young <jyoung0950@xxxxxxxxx> wrote:

V6R1.

Using examples provided earlier this month by Chuck, I have successfully
created After Insert and After Update SQL triggers.
I would like to be able to have a filter on the After Insert trigger so
that only records meeting my selection criteria will be processed.
Is this possible?
I have not been able to find anything in the SQL Reference Manual regarding
this.


TIA,

Jeff Young
Sr. Programmer Analyst

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.