[SalesForce] SObject row was retrieved via SOQL without querying the requested field

I've been trying to understand the example at

http://www.salesforce.com/us/developer/docs/pages/Content/pages_dynamic_vf_sample_standard.htm#pages…

This is from VF Developer's Guide.

I have no luck. I tried to learn the code by understanding every line before typing it in (in other words, instead of copying and pasting). When I got all the code in and ran it, I got this error:

SObject row was retrieved via SOQL without querying the requested field: Account.BillingCity

So instead I created new files and simply copied and pasted the code in again, and got the same error. That means it's not my typo. Something is not working with the code properly. However, I couldn't figure out what the errors are.

I have already executed the reset() before calling the addFields() function on the controller. Is that not good enough?

Best Answer

I tried copying the code into two of my DE orgs. The code worked on a newer org on NA9, but my oldest org on NA12 didn't work. I suspect it has to do with the age of the org. I've seen other things not work in older DE orgs.

Related Solutions

[SalesForce] Error message: SObject row was retrieved via SOQL without querying the requested field

The only fields that are queried by default are the fields that are explicitly bound to the main standard controller during the page's construction (before the constructor of your extension is called).

You have two choices here:

1) You can use StandardController.reset() and StandardController.addFields() to add Name as a field to query.

2) You can bind directly the standard controller's record by using the name of the object:

<apex:page standardController="Installation__c" extensions="CrewWorkDetailController">
    {!installation__c.Name}
</apex:page>

[SalesForce] SObject row was retrieved via SOQL without querying the requested field. Transaction_Survey__c.Transaction_Score_Other_Reason__c

You need to use this in the VF page to have it work:

Transaction_Survey__c.Transaction_Score_Other_Reason__c

instead of this:

survey.Transaction_Score_Other_Reason__c

As it stands, you are only referencing the field in a controller property not the actual object in the StandardController which is why you get the error.

Using what I stated will still populate the survey property correctly when updated and output the value appropriately

Best Answer

Related Solutions

[SalesForce] Error message: SObject row was retrieved via SOQL without querying the requested field

[SalesForce] SObject row was retrieved via SOQL without querying the requested field. Transaction_Survey__c.Transaction_Score_Other_Reason__c

Related Topic