一般的な一括トリガイディオム

1// When a new line item is added to an opportunity, this trigger copies the value of the
2// associated product's color to the new record.
3trigger oppLineTrigger on OpportunityLineItem (before insert) {
4
5    // For every OpportunityLineItem record, add its associated pricebook entry
6    // to a set so there are no duplicates.
7    Set<Id> pbeIds = new Set<Id>();
8    for (OpportunityLineItem oli : Trigger.new) 
9        pbeIds.add(oli.pricebookentryid);
10
11    // Query the PricebookEntries for their associated product color and place the results
12    // in a map.
13    Map<Id, PricebookEntry> entries = new Map<Id, PricebookEntry>(
14        [select product2.color__c from pricebookentry 
15         where id in :pbeIds]);
16         
17    // Now use the map to set the appropriate color on every OpportunityLineItem processed
18    // by the trigger.
19    for (OpportunityLineItem oli : Trigger.new) 
20        oli.color__c = entries.get(oli.pricebookEntryId).product2.color__c;  
21}

1trigger oppTrigger on Opportunity (before delete) {
2    for (Quote__c q : [SELECT opportunity__c FROM quote__c 
3                       WHERE opportunity__c IN :Trigger.oldMap.keySet()]) {
4        Trigger.oldMap.get(q.opportunity__c).addError('Cannot delete 
5                                                       opportunity with a quote');
6    }
7}