Apex Code Development You need to sign in to do that
Don't have an account?
raysfdc1988 maximum trigger depth exceeded s trigger event AfterUpdate
trigger AttachmentandReferralpoints on Student_Profile__c (before insert, after insert,after update) {
if(trigger.isupdate){
list<Referral_Points__c> referral=new list<Referral_Points__c>();
for(Student_Profile__c s: trigger.new){
if(s.Course_Program__c !=null)
{
Referral_Points__c rp=new Referral_Points__c();
rp.Member__c=s.id;
rp.points__c=50;
Student_Profile__c referedpersonid=[select id from Student_Profile__c where UserName__c=:s.Referred_By_email__c limit 1];
rp.Refered_Person__c =referedpersonid.id;
referral.add(rp);
}
}
if ( !referral.isEmpty())
insert referral;
}
}
hi guys....!!
I think its becouse of recusrsive trigger, but unable solve..
Please help me to bulkify this trigger or solve the prob..
if(trigger.isupdate){
list<Referral_Points__c> referral=new list<Referral_Points__c>();
for(Student_Profile__c s: trigger.new){
if(s.Course_Program__c !=null)
{
Referral_Points__c rp=new Referral_Points__c();
rp.Member__c=s.id;
rp.points__c=50;
Student_Profile__c referedpersonid=[select id from Student_Profile__c where UserName__c=:s.Referred_By_email__c limit 1];
rp.Refered_Person__c =referedpersonid.id;
referral.add(rp);
}
}
if ( !referral.isEmpty())
insert referral;
}
}
hi guys....!!
I think its becouse of recusrsive trigger, but unable solve..
Please help me to bulkify this trigger or solve the prob..
replace ur code with this and check it....
if(trigger.isupdate){ list<Referral_Points__c> referral=new list<Referral_Points__c>(); for(Student_Profile__c s: trigger.new){ if(s.Course_Program__c !=null) { Referral_Points__c rp=new Referral_Points__c(); rp.Member__c=s.id; rp.points__c=50; Student_Profile__c referedpersonid=[select id from Student_Profile__c where UserName__c=:s.Referred_By_email__c limit 1]; rp.Refered_Person__c =referedpersonid.id; referral.add(rp); } } if ( !referral.isEmpty()) update referral; } }thanks,pradeep
Actually i am getting this error when i delete any record of parent object(Student_Profile__c)...
and I am creating a new record of referral not updating it..How can i bulkify this code..