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
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() ?
Please give me more shed on this.
Thanks!
Arpan
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())
Please give me more shed on this.
Thanks!
Arpan
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.
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156