Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Problem with DictField.Name returning blank value when using DbBackend::Sql

(0) ShareShare
ReportReport
Posted on by 4,049

I am having a problem with this statement in AX2012.

info(strFmt("%1",new DictField(tableNum(InventTrans), fieldNum(InventTrans, Qty)).name(DbBackend::Sql)));

It simply returns a blank value.

I have Syncronized the Database but I am still not getting a value from the statement.

It does work fine on other tables and field, like:

info(strFmt("%1",new DictField(tableNum(CustTable), fieldNum(CustTable, AccountNum)).name(DbBackend::Sql)));

This returns correctly the value "ACCOUNTNUM"

  • Suggested answer
    Rudi Hansen Profile Picture
    4,049 on at
    RE: Problem with DictField.Name returning blank value when using DbBackend::Sql

    That was all ok, it actually turned out that the table InventTrans had its configuration key disabled, so the table was not available from AX.

    And apparently if thats the case the function DictField.Name simply returns a blank string.

  • Sumit Loya Profile Picture
    2,230 on at
    RE: Problem with DictField.Name returning blank value when using DbBackend::Sql

    Hi Rudi,

    In system documentation, check for table SqlDictionary. Open this in table browser and then check for values where tabId = 177 (For InventTrans). Then check for Name and SQLName columns

    1273.T1.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,127 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,871 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans