[SalesForce] Saving null value to decimal field using apex

I just wanted to check is it possible to save empty value or null value to a decimal field using apex.

Let us take that there is a number field by name Count__c, which needs to be set as blank when certain conditions met. I can do it by workflow field update for new records, but i want to update the existing records. So just thought of writing a script in console, but when i assign a blank value to that field and try to execute it gives me exception that we cannot assign a blank value.

If i can do it via workflow field update why cannot we do it using apex.

Best Answer

I'm guessing you probably did something like this:

record.Count__c = '';

This is not a blank value, it's an empty String. To make a field blank, set it to "null":

record.Count__c = null;

Related Solutions

[SalesForce] Inserting values from one custom field to another using Anonymous Debug Window

You need to use the equality operator (==) in your conditional statement, rather than the assignment operator (=).

Your code also has other issues which will need to be addressed:

SELECT from Producto__c into a List<ProductOrder__c>.
SOQL query inside a for loop.
DML operation (update) within a for loop.
DML operation on a field (po.prod2__c) rather than an object (in this case po).

Since this is a one off operation, you may be able to get away with the second two if you have less than 99 ProductOrder__c objects (since you've already used 1 of the 100 SOQL limit in your first query), but I would recommend trying to bulkify anyway by adding the objects that need to be updated to a list and then calling update on that list..

[SalesForce] How to avoid a QueryException with null SOQL queries

You instead need to be assigning it directly to the list:

List<User> ccUsers = [SELECT Id FROM User WHERE ContactID = :joint.contact__c AND isActive = true LIMIT 1];

if (ccUsers.isEmpty())
{
  //Do something because we found no matching Users
} else
{
  //Do something else because there is a matching user
}

Best Answer

Related Solutions

[SalesForce] Inserting values from one custom field to another using Anonymous Debug Window

[SalesForce] How to avoid a QueryException with null SOQL queries

Related Topic