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…

The correct answer is D. First Only. Speeds up the fetch. Instructs MorphX to fetch only the first record. select firstFast custTable order by AccountNum;

Develop X++ code

Question

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?

Options

AFirst Fast
BFor update
CExists
DFirst Only

How the community answered

(64 responses)

A
5% (3)
B
8% (5)
C
16% (10)
D
72% (46)

Explanation

Speeds up the fetch. Instructs MorphX to fetch only the first record. select firstFast custTable order by AccountNum;

Topics

#select statement#First Only#database query#X++

Community Discussion

No community discussion yet for this question.

Full MB6-704 Practice