web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Give some examples of ...

Microsoft Dynamics AX (Archived)

Give some examples of Fieldlist in X++ code?

(0) Share

Report

Report

Posted on by Community Member

Give some examples of Fieldlist in X++ code?

static void TestNoFetch(Args _args)
{
    CustTable       custTable;
    
    select firstOnly noFetch AccountNum from custTable;
    
    info(custTable.AccountNum); // no value fetched yet
    next custTable;             // move the cursor
    info(custTable.AccountNum); // value
}

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (12)

Answers Img

Answers (1)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

The above code was posted by me while trying to explain what NoFetch is for another community member.

Please explain what do you mean by field list.

If you would like to know what fields are available for a specific table, you can check that in Data dictionary > Tables > TableName > Fields.

Or alternatively you could use reflection with the DictTable class, or using the TreeNode. You could find more information about those by doing some google search.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Kavitha,

What is your real question here?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Give some examples of Fieldlist in select statement of X++ code?

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Repeating the same "give some examples..." isn't an explanation. If the question isn't worth a minute if your time, why should others spend their time?

Unless you explain your problem to us, just look into documentation (Select Statement Syntax) and notice that you have the whole AX application full of select statements that you can use as examples.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The reason why we would like to know more about your question is that you provided a code sample. Is this not working or why is it mentioned?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for your kind reply in briefing the question that i posted to the forum.

Can u provide the examples of fieldlist in select statement in x++ code is required for better understanding?

I have gone through select statement syntax article in msdn website.

https://msdn.microsoft.com/en-us/library/aa656402.aspx

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

I am afraid you still have not answered any of our questions.

What do you mean by field list, and why have you pasted in the code above?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I have asked about the fieldlist in select statement in x++?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Repeating the same "give some examples..." isn't an explanation. If the question isn't worth a minute if your time, why should others spend their time?

Your reply is hurting..

My Question is:Give a brief about the fieldlist in select statement syntax in x++ code?

I have already read the select statement syntax article in msdn.

I required that exaplanation needs more briefing for my development.

Kindly don't repeat the same.I am not wasting any person time.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Kavitha,

The fact you provided a code sample made the question unclear. Was it about how and when to use a field list or did you have some problems with the code sample.

A field list is used to restrict the number of fields that will be retrieved from the database. This will be better for performance as less information will be retrieved which is quicker.

As example you can use:

while select Field1, Field2, Field18 from table

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Alexey Lekanov 2

#2

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans