-
Can we insert parent and child object record in single DML statement?
Can we insert parent and child object record in single DML statement?
-
3 Replies
-
Try something like below: Note that reference field must be external id field on parent object. Here i have used SLASerialNumber__c as external id field.
Contact con = new Contact(lastName=’bhardwaj’);
con.Email = ‘naman.bhardwaj@test.com’;Account accRef = new Account(SLASerialNumber__c=’12’);
con.Account = accRef;Account acc = new Account(Name=’namanTestAcc’, SLASerialNumber__c=’12’);
Database.SaveResult[] results = Database.insert(new SObject[] {acc, con});
for (Integer i = 0; i < results.size(); i++) {
if (results[i].isSuccess()) {
System.debug(‘Successfully Created ID: ‘+ results[i].getId());
}
} - [adinserter block='9']
-
To insert the parent-child object record in single DML statement as follows:
Inserting Custom objects (Parent and Child) records in a Single DML Statement:
here assume Parent__c and Child__c is a custom object:
create a External Id in Parent__c object called Parent_Ref__c.Child__c c = new Child__c();
c.Name = ‘ChildRecord1’;
Parent__c parentReference = new Parent__c(p.Parent_Ref__c = ‘abc1234′);
c.Parent__r = parentReference;
Parent__c p = new Parent__c();
Name =’TheBlogReaders’;
p.Parent_Ref__c = ‘abc1234’;
Database.SaveResult[] results = Database.insert(new SObject[] { p, c });Thanks.
-
Hello,
Yes, you need to make one field as an External id on your parent object.
Thanks.
Log In to reply.
