web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) get field value by fie...

Microsoft Dynamics AX (Archived)

get field value by field id

(0) Share

Report

Report

Posted on by Community Member

hi,

i know table name , table field id and table field name as string .

for example Table1 , with field id 60001 and fieldName - "code" as string ;

i want to get the value of this field from database .

how can i get this information ?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Basheer17 2,720 on at

Like (0)

Report
Copy link

Link copied!

You can get lot of information on the internet. msdn.microsoft.com/.../aa848113.aspx for example.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi David,

What do you mean 'from database'? Are you talking about getting this information using x++ or through t-sql?

T-SQL would be: select field from Table1

x++ would be very similar:

Table1 t1;

while select field1

from t1

{

info(strfmt("my field value is: %1",field1)); // will loop through every record in Table1

}

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (2)

Report
Copy link

Link copied!

i had a problem where I have table field name as string data type. "code","firstname" and etc. you can't loop through table when you have string .

i solved my issue

fieldID = fieldName2Id(tableName2Id("tablename"), "fieldName");

valueStr = table.(fieldID )

you are getting value in valueStr field.

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