Hi all,

i have the following piece of code which runs when i try to deactivate a user :

=================================TRIGGER=======================================================

trigger closeTargetProspect on User (after Update) {

public List<Targets__c> Target_list = new list<targets__c>();

for (User u : trigger.new) {

if(!u.isActive) {

Target_list=[select id,Target_Start_Date__c, Target_End_Date__c, Contact_Owner__c from Targets__c where ownerid = :u.id and Target_End_Date__c = null];

for(targets__c t : Target_list)
{
    t.Target_End_Date__c= date.today();
}
if(target_list.size()>0)
{
    update Target_List;
}
}

}

}

=======================================END====================================================

When i deactivate the user, i get an error message :

Error: Invalid Data.
Review all error messages below to correct your data.
Apex trigger closeTargetProspect caused an unexpected exception, contact your administrator: closeTargetProspect: execution of AfterUpdate caused by: System.DmlException: Update failed. First exception on row 0 with id a09900000022LPDAA2; first error: MIXED_DML_OPERATION, DML operation on setup object is not permitted after you have updated a non-setup object (or vice versa): Targets__c, original object: User: []: Trigger.closeTargetProspect: line 17, column 1

I had read some articles on MIXED_DML_OPERATION on community, but i am unable to get how to change this code to make it work

a piece of code i had found was :

===============================================================================================

private static void myFunc()

{

     ///1st DML operation

     User usr = [Select id from User where Id = :UserInfo.getUserId()];

     System.RunAs(usr)

     {

        Test.startTest();

         myFunc2();

         Test.stopTest();

     }

}

@future

private static void myFunc2()

{

   ///2nd DML operation

}

============================================================================================

I am not sure how to implement the methods in this trigger or how to make a call from this trigger to a seperate class where this method belongs.

Could you please help me out with changing the code?

Thanks in Advance

Rajat.