Variable text string for SObject get method?

Question

I want to use a variable string rather than a hard-coded string in my get method.

For example, for every Field in Object A there will be a record in Object B and the record name is the field api name from Object A. I want to reference Object B's name in a Object A dynamic soql query:

String fieldName = objectB.Name
Sobject objectA = Database.query('Select Id From ObjectA__c Where Id = \'' + ObjectB.Object_A_Id__c + '\' Limit 1');
objectB.Number_Field__c = (integer)objectA.get(fieldName);

​I don't know if this is possible. I get the error System.TypeException: Invalid conversion from runtime type Id to Integer. Still new to Apex coding.

Answer 1

As I understand your question:

1. ObjectB records will have the NAME field set to the API name of a field in ObjectA
2. You want to populate ObjectA field specified by ObjectB.Name with a value

For example

sObject objectB = [Select Name, Value__c From ObjectB Where Id = 'XYZ'];
ObjectA__c.put(objectB.Name,objectB.Value__c);

For the most part if the field types are the same you should be ok. BUT, if the field types are different then you are going to have to identify the appropriate type and cast it by ([TYPE])objectB.get('Value__c');

Maybe more clear

String fieldName = 'AccountId';
sObject opp = database.query('Select Id ' + fieldName + ' From opportunity Where Id = XYZ');
Contact objectB = New Contact(AccountId = (Id)opp.get(fieldName));

Or maybe I did not follow what you are trying to do with the code

Answer 2

I think you need to add fieldname to your query. You're basically trying to access a field you're not querying:

Database.query('Select Id, ' + fieldName + ' From ObjectA__c Where Id = \'' + ObjectB.Object_A_Id__c + '\' Limit 1');

That is my initial thought just looking at your code.

With respects to your type error, if you are entering a fieldName that is not of type number, you're going to run into issues. You wont even be able to type cast this. You need to make sure fieldname is the same type as the variable you're trying to assign it to. In most cases, this will be string.

objectB.String_Field__c = string.valueOf(objectA.get(fieldName));

This should allow you to enter any field into fieldName and populate the field based on the value recieved.

If you are dead set on using a number field, try something like:

IF( string.isnumeric(objectA.get(fieldName)) ) {
    objectB.Number_Field__c = (integer) objectA.get(fieldName);
} else {
    // Do something with your error
}