Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
what is use of buffer table?
mdsr
Member Posts: 163
i have seen buffer table in many location in navision but i don't understand why it is used can any one give small and simple example
thanks in advance.
thanks in advance.
-1
Answers
For example Excel Buffer table is used to create excel file and hold data in memory temporarily while excel file is created.
When to use buffer and when to use integer table.
The Integer table is virtual table, you can't find this table in DevEnv but you can use it in report dataset. This table is used for additional loops for some cases in the reports. The most common scenario where is used is for RoundLoop and CopyLoop for the reports. In this table as filters you can use it all integer numbers in DataItemTableView property. For example you can see Report 206.
The Buffer table can be any of the table you see in DevEnv. When you use the table as variable or as a part of the report data set, in the property Temporary you must set the value Yes (and here you must be very careful to don't forget this step when you use buffer (temp) tables cause you can use DELETE function in temp tables and if it's not declared as temp you can delete all the data from that table).
For example I need to read data from Item table and I like to get a list from all Items under some conditions. Then I can use Item as buffer (temp table) and one more variable which is regular as Record. I set the conditions in regular an while you read the data you fill the temp table:
RecItem.SETRANGE("Item Category Code", "DOOR");
IF RecItem.FINDSET THEN
REPEAT
TempItem."No." := RecItem."No.";
TempItem.Description := RecItem.Description;
TempItem.INSERT;
UNTIL RecItem.NEXT = 0;
Integer and buffer tables are completely different kind of tables.
BR