Access class's value from a trigger

Question

I am writing a trigger for the object OpportunityLineItem to set for all new records the field section__c.

trigger setsection on OpportunityLineItem (before insert)
{
    for (OpportunityLineItem opp: Trigger.new )
{ 
      opp.section__c=
}
}

I want set the field section__c for all new record with the value of the field SectionID of the first record of another object named SectionopportunityProduct Object SectionopportunityProduct has ever just one record.I want get the value from this.

There isn't a relationship between opportunitylineitem-SectionopportunityProduct. How can I do this?

Thanks in advance for any advice. BR

Answer 1

Easy & Fast & really not the best practise

trigger setsection on OpportunityLineItem (before insert)
{
      SectionopportunityProduct temp = [SELECT field_you_need FROM SectionopportunityProduct  LIMIT 1];
           //if there ever are multiple records this query can not predict which record you receive 
           //update: this will also fail if there is no data. Take into account normal development practises around these scenarios
      for (OpportunityLineItem opp: Trigger.new ){ 
           opp.section__c= temp.field_you_need;
       }
 }

However If you have an object which you only intend to use for a single record, containing some values you may be better of with a different approach. If the values you are storing are basic types you could store them in a list custom setting which will still allow admin configurability.

http://help.salesforce.com/help/doc/en/cs_about.htm

If the values you need are likely to never change you could also store them in a static class as public static variables. Changing would require deployment as this is apex.

Or .. even simpler, you could use a field update workflow.

Options are pretty general and the specific choice would depend on the overall thing you are trying to implement.