Use this tag for questions about DML, the data manipulation language used in apex to perform operations as insert, update, delete, and restore data in the database.

learn more… | top users | synonyms

3
votes
0answers
21 views

Add Error on standard list view

does someone know how to show an error in an object's listview after a dml operation? I have written a simple trigger that prevents user to delete closed opportunity List<Opportunity> ...
1
vote
1answer
13 views

Copy EventRelation data to a custom object

I'm trying to add a field to track event attendance (not just accepted response). I've created a custom object and a visualforce page. The problem I am having is copying the EventRelation data to ...
2
votes
1answer
20 views

Upserting objects in Apex: can I assert which have been inserted / updated?

I'm upserting a list of custom objects in an Apex controller that are retrieved on demand from an external source. My object has an external identifier field used to help the database call determine ...
4
votes
2answers
63 views

Will SFDC manufacture batches from concurrent operations?

So, like all SFDC developers worth his/her salt, I know when writing triggers and other code, we need to bulkify. And I have a pretty good handle on how to do that, so I am not asking about that. ...
1
vote
1answer
37 views

System.SObjectException: Field is not writeable: CampaignMember.ContactId

Can anybody help me figure out why Salesforce is saying the Campaign Member ContactId field is not writeable? I have Dedupe logic that runs on Contact after insertion, if it matches an existing ...
1
vote
2answers
45 views

Problem with Database.update()

I have some accounts to update but some validation rules can failed. So to avoid this I use the Database.update() function to update accounts even if some DML exception occur. try { ...
2
votes
0answers
50 views

Sharing Records

I have an org that was recently updated to API 32, which broke some triggers that create Sharing Records. This code worked previously to the update to API 32. public void ...
4
votes
2answers
142 views

Database Class Methods

A noobie question. Is Database.Update bulkified by itself ?. I know it is similar to "update" but just wanna confirm that this alternate version of DML is auto bulkified. For example let us assume ...
0
votes
1answer
37 views

@future solves ERROR: MIXED_DML_OPERATION but Batch fails

A user is automatically created in the backend whenever a contact is created in the sf console. A custom field, DivisionCs is filled during that automated process. We want the same field to be updated ...
1
vote
1answer
16 views

Cases added with Prefix as “RE”.How to display them in a while Statement

We do get case added with the Prefix as " RE " or "FW "So we give them in a while stmt ,as : while(c.Subject.startsWith('RE:') || c.Subject.startsWith('FW:')) Similarly case added with the Prefix ...
7
votes
1answer
118 views

Database.DMLOptions - How to prevent Chatter Group Auto-Follow trigger from generating email

Currently I have a trigger which auto-follows specific groups in our organization when a new user is brought onboard. The auto-follow trigger feature works great! However, we have quite a few groups ...
2
votes
1answer
83 views

Mass update: Required field is missing

I deployed a trigger and trying to update all records to populate custom field of existing records with value ( account object ). Everything works perfect unless I get the following error: ...
2
votes
1answer
96 views

Why record is removed on exception thrown

I'm inserting and updating a new record before throw an exception like this: Operation__c o = new Operation__c(ok__c = false,Step__c = 'test1'); insert o; system.debug(o); //this shows the Id try{ ...
5
votes
1answer
142 views

'After' trigger's SOQL - will query fetch current value of the inserted/updated record?

I want to get data from children objects and populate field at parent object. I used after insert & update trigger to get the information. If I run a query on inserted/ updated object in a ...
2
votes
0answers
37 views

How to update the current login user

I have a custom field over my user object. And I want to update this user by the contact id from apex. How can i update the user record in salesforce. Because when I trying to update the field of ...
1
vote
1answer
27 views

call dml insert listofSObject from a controller that is referenced in apex page

Is it possible to call dml operations like insert list_SObject ; inside a controller method that is refrenced in visualforce page not some trigger class? please give some references.
0
votes
2answers
40 views

Trigger is not updating a lookup field

Resolved. Object's sfid wasn't created yet. Changed the trigger to after trigger. I've looked at other posts, but for some reason I cannot find a solution. Basically, when a new object is inserted ...
1
vote
1answer
23 views

Is there a predetermined order that Database.SaveResult is returned?

Let's pretend the scenario below: List<Account> acc = new List<Account>{...}; List<Database.SaveResult> results = Database.insert(acc, false); Will the Lists have associated ...
1
vote
1answer
28 views

Why am I getting SaveError: Variable does not exist: AssigneeId?

I have entered the following code entered in the Force.com IDE: @RestResource(urlMapping='/PermissionSetAssignment2/*') global with sharing class PermissionSetAssignment { @HttpPost global ...
3
votes
2answers
69 views

Why is my locked record editable?

Why is my record locked? The record that the class below creates, when shown in detail view, has the 'locked' icon, and appears to be locked at first view, but- Why can I edit the locked record (Even ...
6
votes
0answers
58 views

Email value is saved without parentheses (label) when using DML

When an email contains a label enclosed in parentheses, the value can be saved as typed in via SF UI. (Note: the email value "as is" is only seen when in Edit mode.) However, when the record is saved ...
2
votes
2answers
98 views

What to use for performing operations on multiple records at once, Apex REST class or Bulk API?

I need to insert/update/delete a variable number of records at a time from a webapp (so from javascript), are there reasons to choose the Salesforce Bulk API over writing a custom Apex REST class to ...
2
votes
1answer
27 views

Can you delete AccountHistory data?

Does anyone know if it's possible to delete AccountHistory data? Bonus points: Is there an easy way to find the total number of AccountHistory records in an org?
-1
votes
1answer
68 views

Realtime scenerios on dml and database class methods [closed]

can anyone provide links or tasks or whatever possibilities on dml operations otherthan force.com developer guide. plz... As i understood concepts on insert,update,upsert,delete and also database ...
2
votes
1answer
70 views

Is it bad to update a a list of a size greater than 200 in DML

I am reading the existing code in the project. In the code: if(aUpdates.size() + aList.size() > 200) { update aUpdates; aUpdates.clear(); aUpdates.addAll(aList); } else { ...
1
vote
3answers
204 views

Changes to trigger.new upon Sobject Event within before update are not sticky

I have a custom object that creates a calendar event via a trigger and it works fine. However, if the user attempts to change calendar event fields from the calendar edit feature, I want the fields to ...
0
votes
1answer
110 views

Apex Error: Too Many SOQL Queries: 101 [duplicate]

I am currently trying to update a set of data, but I am receiving the error "Too Many SOQL Queries: 101". From what I have seen while searching around, this is normally an error that occurs while ...
2
votes
1answer
121 views

DMLOptions 'useDefaultRule' for an account's update - not working

I'm trying to assign DML options to an account's update. It's working with the insert, but not wit an update. Here is the code I'm using: Database.DMLOptions dmlOpts = new Database.DMLOptions(); ...
4
votes
1answer
209 views

New Customer Portal user email even when triggerUserEmail = false

I'm trying to write an Apex web service that can create a customer portal user. After creating the user, there is a separate step which does a password reset for the user and sends them an email. The ...
0
votes
1answer
63 views

Updating a record without DML

I am writing an after update trigger on OpportunityLineItem that will update an opportunity based on values retrieved from it's respective line items. By sheer accident, I forgot to include the ...
1
vote
1answer
130 views

List Exception caused by trigger

I have some code in a trigger that works when tested, and works in my sandbox, when I get it into production every time something happens where the trigger should go off, I get this error: Apex ...
6
votes
2answers
93 views

DML not allowed on ApexClass

I am trying to move around 80 classes and visualforce pages from sandbox to production by using change set but i got an error One or more components failed Version Compatibility Check. This ...
3
votes
3answers
492 views

Can I rollback a Before Insert trigger from an after trigger event?

Scenario: After an object is inserted/updated (can happen after any of the two) - I update an external system with that object's info - Object ID is needed - which is why I need the After Insert. ...
0
votes
2answers
97 views

Got the Workflow Field Update working. What is the equivalent DML?

In the Formula part of a Field Update Workflow I was able to update a custom field in my Activity Assignment record with the email address of the Owner from the parent Sales Opportunity, using: ...
1
vote
1answer
59 views

Changing org-wide sharing settings from Apex

We have an object whose Org-Wide default sharing setting is set to Private. When an Admin changes a Picklist to Full Access, we have to insert CustomObject__Share records for all users, and ...
6
votes
1answer
2k views

Database.SaveResult - how to get the Id of the record where Update failed?

I am using Database.SaveResult and Database.update(..., false) for the very first time and ask myself how to get the Id of the record where a dml has failed. I expected Database.SaveResult.getId()` ...
4
votes
1answer
152 views

Chatter in Apex: is it DML?

So there's times you can't DML (getters, constructors, components without allow DML, etc). Can we use chatter in apex, or is that also considered inserting records?
5
votes
1answer
40 views

Is DML allowed in the current context?

So I can check for isbatch, isfuture, etc... Is there a way to know if the current context allows DML? We've implemented a exception logging object, but if a class is called from a getter or ...
6
votes
1answer
128 views

Do triggers run asynchronously when triggered by DML in apex?

The question is fairly self-explanatory, but to add a little background, here's the scenario that has made me ask. First a (very basic) SSCCE: public void createAttachments(List<Account> ...
3
votes
1answer
105 views

DmlException Question

This question is related to a previously answered question: Trigger won't Fire It looks like my organization has an existing test class that isn't playing nicely with my new Trigger. Could ...
0
votes
1answer
599 views

can't call the custom field on custom visualforce page

i m trying to learn about visualforce page based on my understanding, after reading the material from web and workbooks. I created an C.Object called Book__c and calling custom fields to a visualforce ...
7
votes
1answer
199 views

Avoiding Mixed DML (setup/non-setup) Approach

I need an approach to allow delegated admins (i.e., non-Administators) to add members to Public Groups and Collaboration Groups (the GroupMember and CollaborationGroupMember objects). I added a ...
0
votes
2answers
613 views

How to set reference Object's value before insert?

Object a has many of object b, How can I determine an object reference before insert ? When I determine object b information for example number, name, .. and I want to insert it to an object of ...
1
vote
2answers
149 views

What does the insert statement do?

For instance: Country__c newCountry = new Country\__c(); newCountry.CountryName__c = 'GlobalLogic'; newCountry.IsActive__c = true; insert newCountry; // why we are using insert statement ...
5
votes
2answers
1k views

where do I use Database. Methods?

I m trying to understand where we use following Database.Methods. I know if we want to insert a record to an object we use DML Statement. What i want to know is why/where we use Database. methods. It ...
1
vote
2answers
451 views

failure message system.dmlexception insert failed

//this is my before insert trigger public with sharing class Account_Amount { public Account_Amount(){} public void calAmmount(List<Account> accList){ AccountDiscount__c mc = ...
5
votes
2answers
755 views

How does salesforce calculate DML rows? What is included to DML Rows Count?

Does anyone know how does salesforce calculate DML rows? What is included to DML Rows Count? Consider following code which hits "System.LimitException: Too many DML rows: 10001" ...
8
votes
1answer
338 views

Is upsert properly ACID compliant?

Given an object Table_A with one unique field Unique and two rows: row Unique --- ------ 1 A 2 B And the following class: public class KeySwapDML { public void ...
3
votes
1answer
72 views

How insert operation on SObject having neither triggers nor workflow rules can cause exhausting of SOQL query limit?

Mystery of DML operation: if SObject doesn't have neither triggers nor workflow rules, how insert operation on it can cause exhausting of SOQL query limit? I have faced today again with exhausting of ...
8
votes
2answers
1k views

How do I delete records in the recycle bin?

I understand that when I perform a Database.delete() operation, records will end up in my org's recycle bin. And their presence in the recycle bin is reflected by the IsDeleted field on the object. ...