Home » Microsoft » MB6-704 » Which keyword should you use?
You are writing logic to fetch data from a database. The logic will use a select statement.
You need to identify which keyword to use to fetch a single record from the database.
Which keyword should you use?
A. FirstFast
B. ForUpdate
C. Exists
D. FirstOnly
Correct Answer: D
Explanation/Reference:
firstOnly
Speeds up the fetch. Instructs MorphX to fetch only the first record.
Example:
select firstFast custTable
order by AccountNum;
Reference: Select Statement Syntax [AX 2012]