Why we can't use DML before trigger in Salesforce?

Hello Madhulika,
In Before Triggers, actions are being performed before you commit the record to the database. This is where you usually do validations or updates to the same object. You can skip the DML operations here as whatever values you give in your code is automatically assigned to that record.

• This reply was modified 8 years, 2 months ago by  Prachi.

The idea is to help avoid recursion. You cannot perform DML on the records which are stored in the trigger context variables. You can however retrieve them using the Ids (or create a new object referring to that record with the same Id ) and then update this. You still have to manage recursion properly though by using a static variable which can be resued over the contexts. For example:

Trigger AccountTrigger on Account (after insert) {

if(isAfter() && isInsert()){
AccountTriggerHelper.performAfterInsert();
}
}

public class AccountTriggerHelper {

public static boolean isExecuting = false;

public static void performAfterInsert(){

if( TriggerHelper.isExecuting ){
// if was executed during the same context
// avoid recursion
return;
}

TriggerHelper.isExecuting = true;

//list of new instance of object to update.
Account[] accounts = new Account[]{};

for (Account a: Trigger.new) {
//here the magic by creating a new instance using the same id
Account aux = new Account(Id = a.Id);
aux.Name = a.Id + 'Value forced to be set after by an extrange req';
}
//then update the new instance list.
update accounts;

}

}

Hope this will you.

Thanks