Apex DML 関連レコード追加 更新 削除のサンプル
環境
Salesforce
追加
Account acct = new Account(Name=’SFDC Account’);
insert acct;
ID acctID = acct.ID;
Contact ct = new Contact(
FirstName='Mario',
LastName='Ruiz',
Phone='415.555.1212',
AccountId=acctID);
Contact ct = new Contact(
FirstName='Mario',
LastName='Ruiz',
Phone='415.555.1212',
AccountId=acctID);
Contact ct = new Contact(
FirstName='Mario',
LastName='Ruiz',
Phone='415.555.1212',
AccountId=acctID);
insert ct;
更新
Contact qContact = [SELECT Account.Name
FROM Contact
WHERE FirstName = 'Mario' AND LastName='Ruiz'
LIMIT 1];
Contact qContact = [SELECT Account.Name
FROM Contact
WHERE FirstName = 'Mario' AND LastName='Ruiz'
LIMIT 1];
Contact qContact = [SELECT Account.Name
FROM Contact
WHERE FirstName = 'Mario' AND LastName='Ruiz'
LIMIT 1];
qContact.Phone = '(415)555-1213’;
qContact.Account.Industry = 'Technology’;
update qContact;
update qContact.Account;
削除
親オブジェクトを削除すると、各子レコードが削除可能な場合は
自動的に削除されます。
Account[] qAccounts =
[SELECT Id FROM Account WHERE Name=’SFDC Account’];
delete qAccounts;