Trigger on Opportunity that update the Account Object

I have created a custom field called 'Status' on the Account object. I has three picklist values : Prospect, Active and Dormant

The default is Propects' I an Opportunity is Closed -Won then I want to update the Account.Status field to Active

I started with the following code

public class OpportunityUpdateClass{

   public stats void UpdateAccountStatustoActive(Opportunity[] opps){

         Map<String,Opportunity> oppMap = new Map<String,Opportunity>();

          for (Opportunity opp:opps){
               Account accounts = [select id,name,industry from account where id in :opp.accountid];
                for (Account acc: accounts){
                      if (acc.status__c != 'Active'){
                          acc.staus__C = 'Active'
                      }

}

}
}

June 26, 2008
·
Answer
·
Like
0
·
Follow
0

micwa
You forgot to update the account:

Code:
trigger Test on Opportunity (after insert, after update) { Map<Id,Opportunity> opps= Trigger.newMap; List<Account> accToUpdate= new List<Account>;
for(Account a : accounts){
accMap.put(a.Id, a);
}

for (Opportunity opp : opps){
Account accounts = [select id,name,industry from account where id in pp.accountid];
for (Account acc: accounts){
if (acc.status__c != 'Active'){
acc.staus__C = 'Active';
accToUpdate.add(acc);
}
}
}

update accToUpdate;

}