Using sObject variables in Execution Context

Question

I started learning about Execution Context and I got this question:

Let's say I have a static sObject variable in the beginning of my Execution Context filled by a select. In the middle of the execution, I update a custom field of this sObject. If I get the value at the end of the Execution Context, which value do I get? The new one (even though I haven't selected it again) or the old one?

Thanks.

Answer 1

You will get the updated version, assuming you modified that sObject.

sObject s = [SELECT Id FROM sObject];
s.put('SomeField__c', 'new_value');
update s;
System.assertEquals('new_value', s.get('SomeField__c'));

As long as you modified and did your "update" using the original sObject, then all's well... insert and update work by doing the action, then returning the results right back to your original variable (for example, when you do an insert, you get the exact same object back in it's place PLUS the new Id that was just assigned/created)

sObject s = new sObject();
System.assertEquals(null, s.get('Id'));
insert s;
System.assertNotEquals(null, s.get('Id'));