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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 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
Can i use settableview sending a temporary table?
navusermarf
Member Posts: 1
Hi friends,
How to run a form object variable whose SETTABLEVIEW has Temporary Record set.
Actually I want to see real data & temp data from the same form object.
How to run a form object variable whose SETTABLEVIEW has Temporary Record set.
Actually I want to see real data & temp data from the same form object.
0
Best Answer
-
Options
vaprog
Member Posts: 1,118
What object type?
Anyway, you need to pass in the temporary record as a parameter or build the temporary table within the object.
Obviously, you cannot mix temporary and "real" data in one repeater / dataitem. You need to use a second dataitem, or copy the required records to the temporary table.
SETTABLEVIEW is the same as GETVIEW on the parameter and SETVIEW on the first dataitem with the same table id. Therefore it passes on filters and key only. Not sure if all filtergroups are respected (like COPYFILTERS), or only filters in the current filtergroup (like GETFILTERS or GETVIEW).1
Answers
Anyway, you need to pass in the temporary record as a parameter or build the temporary table within the object.
Obviously, you cannot mix temporary and "real" data in one repeater / dataitem. You need to use a second dataitem, or copy the required records to the temporary table.
SETTABLEVIEW is the same as GETVIEW on the parameter and SETVIEW on the first dataitem with the same table id. Therefore it passes on filters and key only. Not sure if all filtergroups are respected (like COPYFILTERS), or only filters in the current filtergroup (like GETFILTERS or GETVIEW).