Announcements
No record found.
Hi, i need to pack all the records of a temp table into a container.
I need this so that i can unpack and create temp table on another tier (client).
Thank you
Santosh.
*This post is locked for comments
take temp table data in common buffer.
buffer2con(common)
Why don't you simply use a TempDB temporary table?
What you're trying to do sounds like wasting of resources to me.
again you have to do common = con2buf(container) after passing to server site.
Bhaskar, i would want pack all the records not just one.
Martin, even in the case of TempDB table, isn't it better pack it in a container and unpack it another tier instead passing it by Ref ?
Regards
If you use a TempDB temporary table, it exists neither on client nor on AOS - it's in TempDB database on database server. What you're talking about makes sense for InMemory tables only.
all the records means there is no limit. if you want to take it in container, it could give overflow in some scenario when data will be huge. It is not a good practice. so if your code in client tier if you are using im-memory table, it should not pass as argument in server tier. Please make the table property tempDb and use it in server tier for unpack.
use tmpTable.linkPhysicalTableInstance(table) to pack it and send.
linkPhysicalTableInstance() doesn't pack or send anything - it merely connects an AX buffer (X++ variable) with a table instance in TempDB database.
Hi Martin,
yes, Just i provide the method because tmpTable won't work with .setTmp(). if he needs to to carry the data in different instance, he should use above function.
Thanks
Bhaskar
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
