Site Menu
- Home
- Products
- NexusDB
- Nexus Quality Suite
- NexusDB Drivers & Connectors
- Nexus Remoting
- Nexus Memory Manager
- Some of our Customers
- Testimonials and use(r)s
- Downloads
- Documentation
- Support
- Pricing & Orders
- About
- Community
- My Nexus
- Recently Updated ...
- Search...
- Site Login
Search
Updating Predicate


Testing if a trigger event is UPDATE.
Syntax
Notes
♦ | The UPDATING predicate can only be specified in the body of a trigger definition to check the trigger event. |
♦ | The predicate evaluates to TRUE if the trigger was activated by an UPDATE operation on the table, else to FALSE. |
Examples
1) | The following example shows how the UPDATE predicate is used in the WHEN clause of a triggered action: |
WHEN ( UPDATING )
triggered SQL statements
2) | The following example shows how the UPDATE predicate is used in a triggered SQL statement: |
IF UPDATING THEN ... END IF;
Conformance
NexusDB extensions |
- |
UPDATING predicate |
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
Site Updates
- Dec 2 2020 - 7:58pm
- Dec 2 2020 - 7:21pm
- Oct 30 2020 - 1:14pm
- Sep 21 2020 - 11:36am