tell me what is meant by firstonly,firstfast,forceliteral,forceplaceholder.
*This post is locked for comments
First Only:
The word first only denotes to fetch first record only. Let me show an example with firstonly keyword and without firstonly keyword
Example without Firstonly keyword:
static void firstfind(Args _args)
{
SalesTable salestable;
;
while select * from salestable index hint CustIdx where salestable.CustAccount == "124578"
info(strfmt("The output is %1",salestable.SalesName));
}
If you run the above code it will display all salesname based on condition(Equal To) mentioned . . Here you will get all the records as output that satisfy the condition.
Example with Firstonly keyword:
static void firstfind(Args _args)
{
SalesTable salestable;
;
while select firstonly * from salestable index hint CustIdx where salestable.CustAccount == "124578"
info(strfmt("The output is %1",salestable.SalesName));
}
If you the run the above code it will all records based on condition(Equal to) mentioned and will return the first record from the condition satisfied. So you will get only one record as output.
These are hints and query modifiers that affect 1) which query plan a DBMS uses, 2) how AX creates queries. See also Select Statement Syntax
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156