Single Choice Easy

QYou want to update a record in your SampleTable table that contains the account number 1234 by using the update method. Before you call the update method, which clause is used at the beginning of this statement to locate the record sampleTable.AccountNum == “1234”?

ID: #11009 Classes in D365 F&O X++ 278 views
Question Info
#11009Q ID
EasyDifficulty
Classes in D365 F&O X++Topic

Choose the Best Option

Click any option to instantly check if you're correct.

  • A where sampleTable.AccountNum == “1234”
  • B locate sampleTable.AccountNum == “1234”
  • C join sampleTable.AccountNum == “1234”
  • D forUpdate sampleTable.AccountNum == “1234”
Correct Answer

Explanation

  • A. Correct: A where clause is used to specify a condition that the update method will test as it processes each row of the SampleTable table.
  • B. Incorrect: The locate clause doesn’t exist in coding for finance and operations apps.
  • C. Incorrect: A join clause links two tables on a column that is shared by both tables. It doesn’t locate a specific record.
  • D. Incorrect: The forUpdate clause is used to specify the table, not a record that you'll be updating.

Share This Question

Challenge a friend or share with your study group.