You need to sign in to do that
Don't have an account?
hy.lim1.3897974166558203E12
need help move my selecte statement from my for loop (trigger)
Hi i have a trigger in my custom object and it hit governor limit due to select statment in my for loop. now i would like to move my statement out. can anyone help? here is my trigger:
trigger CalculateMorgage on Property__c (before insert) { for(Property__c pp: Trigger.new){ List <House_Type__c> ht = [SELECT ID, Property_Type__c FROM House_Type__c WHERE Range__c =: pp.range__c and Quantity__c =: pp.p_quantity__c]; if(!ht.isempty()){ for(House_Type__c htt:ht){ pp.type__c = htt.Property_Type__c ; } } } }
Range__c Quantity__c Property_Type__c
R_10 10 AC01
R_10 50 AC02
R_10 500 AC03
so if my quantity is 25 and range is R_10 it will return AC02 & AC03 but i need only AC02