Apex Data Manipulation (DML) Operations

Apex Data Manipulation Language(DML) Operations in Salesforce

 Use Data Manipulation Language (DML) Operations to insert, update, delete, and restore data in a database.We can execute DML Operations using two different forms.

1. Apex DML Statement, Such as

Insert SObject();

2. Apex DML database methods, such as

Database.saversult() result=Data Insert(SObject()); --->The following example that inserts a new invoice statement by calling insert and if we execute in the 'Developer console" that creates a record into the database. Invoice_Statements_c Inv=new Invoice_statement_c(Description)c='capital info solutions'); Insert Inv ---> Inserting the invoice using DML. Note:- After the invoice statement is inserted the sobject variable inv will contain the ID of the new invoice statement. * The following example shows the creating records through API for Account object using Insert DML Operation.

Account a=new Account();
 a.Name='Osmania University';
 a.Phone='9052-----';
 a.Email-c='capitalinfosol@gmail.com',
 a.Billingcity='Hyderabad';

Insert a;---> this means assigning the field values to account record

Enthusiastic about exploring the skill set of Salesforce? Then, have a look at the Salesforce Training Course together additional knowledge.

DML Operation used for inserting a record----> The following example shows the creating a contact through API using DML operation (Insert)

Contact C= new contact();
 C.last name='Anil';
 C.Account id='XXX'

Override any account id here //This means assigning account to a contact

Insert C;
 Systerm.debug(C)

Note:- For custom Objects;

Customer_c C=new customer_c();
 C.Name='Anil';
 C.partner_c='xxxx';

API Name of lookup filed or MD field Insert c; Customer__c is child object and partner__c is parent object Note: while inserting the object records the following notes

• Certain SObjects cannot be created to insert an object record because the ”create” permission of the object must be set to true
• We must supply a non-null value for all required fields
• The “insert” statement automatically sets the ID value of all new subjects records
• We can pass a maximum of 10,000 SObject records by using a single insert method.

For indepth understanding of Salesforce click on

• Annotations in Salesforce
• Loops in Salesforce
• Introduction to Apex
• Apex Data Manipulation
• Creating Apex Classes
• Salesforce Training In Houston