Notifications
Announcements
No record found.
Hi,
I would like to ask for help on how to get enum using resultset method. Hoping for your prompt response. Thank you.
Sincerely,
Ivan
*This post is locked for comments
Hi Ivan Siason,
Enums are stored in DB as integer.
So if you have NoYes::Yes in your table resultset will return you 1 for example.
in the resultset can use display method?
why do you want to use display method ?
will it get the result of the name of the enum based from value?
seems you are using ODBC to read data from some external source and you might be looking to convert int value to enum.
Am I correct?
Can you elaborate your question, what do you want to get and where ?
If you have a field on your table e.g. MyTable.MyField you can either do
MyTable.MyField = NoYes::Yes or
MyTable.MyField = 1
result would be the same because enums are integers behind the scene.
So you can declare a variable NoYes noyes = 1;
and when you will do info(strfmt("%1", noyes); AX will show "Yes".
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Priya_K 4
Martin Dráb 4 Most Valuable Professional
MyDynamicsNAV 2
