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
- 267 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
Temporary table
DesmedtS
Member Posts: 53
How can i let a subform show the records of a temporary table (defined in globals as record with property temporary = yes)
Thx
Thx
0
Comments
<STRONG>How can i let a subform show the records of a temporary table (defined in globals as record with property temporary = yes)
Thx</STRONG><HR></BLOCKQUOTE>
To do this you must first have designed a form to display the contents of the permamnent table in the normal way. Then you need to run the form from the place in code where you have your temporary table using the FORM.RUN command and passing the tempoaray table as a parameter. Do not try to do this by declaring the form as a variable and then using the SETTABLEVIEW command as this will not work.
Take a look at Form 344 and the triggers OnFindRecord and OnNextRecord.
You should make a function in the subform that can copy the temptable from the mainform to the subform. Then you just need to copy the code from the two triggers in form 344.
Please note that a simple TempRec1 := TempRec2 only copies one instanse and not the entire temptable. You need to start by flushing the subforms temptable, and then copy them one by one.
Peter