Share
ReportHi
What is the difference between Temporary table and Integer DataItem in Reports.
Thanks
*This post is locked for comments
You’re offline. This is a read only version of the page.
3,099
Hi
What is the difference between Temporary table and Integer DataItem in Reports.
Thanks
*This post is locked for comments
Read this:
www.dynamics101.com/temporary-datasets-reports-dynamics-nav-2013-r2
It's not about the difference, it's about when to use each of them. Temp is for data storage and Integer DataItem is for looping and counting.
Hi jsshivalik,
1. A temporary table is a temporary variable that holds a table. A temporary table is used as a buffer for table data in your C/AL programs. You can use a temporary table just like you use a database table. The differences between a temporary table and a database table are as follows:
- A temporary table is not stored in the database, but is only held in memory until the table is closed.
- The write transaction principle that applies to a database table does not apply to a temporary table.
Advantage of a Temporary Table:
- The advantage of using a temporary table is that all the interaction with a temporary table occurs on the client. This reduces the load on both the network and the server.
- When you want to perform many operations on the data in a specific table in the database, you can load the data into a temporary table when you modify it. Loading the data into a temporary table speeds up the process because all the operations are performed locally on the client.
2. The Integer virtual table includes integers in the range –1,000,000,000 to 1,000,000,000. The Integer virtual table contains only one field. By applying a filter to the Integer virtual table, you can easily get a subset or range of numbers that can be used to control looping in reports.
I add only that Temporary tables are created in memory as empty tables and the object is disposed at the end of your usage.
All responses (
Answers (
