Microsoft Dynamics AX (Archived)

Shall we use Temp Table (In Memory and Temp DB) both in Form datasource?

(0) Share

Report

Posted on by @rp@n

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

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

You can use temporary tables as form datasources if needed.

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thanks Martin,

So, when to use setTmpData() ?

Please give me more shed on this.

Thanks!

Arpan

Was this reply helpful? Yes No
Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thanks Martin

Was this reply helpful? Yes No
Karthickks 100 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

Yes, both can be used as form data sources.

Was this reply helpful? Yes No