Notifications
Announcements
Dear All,
Can you please let me know in form datasource shall we use Temp Table both (InMemory and TempDB)?
Please give me more shed on this.
Thanks!
Arpan
*This post is locked for comments
Yes, both can be used as form data sources.
Hi @rp@n,
What is the answer to this?
can we use in-memory table as a form DataSource or TempDB as a form DataSource?
Thanks Martin
For InMemory tables.
These things are explained on quite a few places, such as in Temporary Tables (AX 2012) on the Microsoft Dynamics AX Support blog. You can use search engines to find that by yourself.
Thanks Martin,
So, when to use setTmpData() ?
No, you must use linkPhysicalTableInstance() for TempDB tables instead of setTmpData().
Use cross-references in AX or put the method name to a search engine if you want to see some examples.
Thanks Vilmos,
Ohh...
So, if required temp table then TempDB is Preferable right ?
And to get data from InMemory or TempDB , we need to use
TempTable.setTmpData(element.PopulateRecords())
You can use it, but to populate values it takes additional computational time compared to just binding it to an actual table with a database fetch.
Be aware that AX is not too great with passing inmemory temporary record buffers between server- and client-tier when you are about to bind the values to the datasource, I have seen odd behaviour when doing that some time ago.
You can use temporary tables as form datasources if needed.
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.
TAHER Mehdi 3
Martin Dráb 2 Most Valuable Professional
Volodya 2
