Temporary Tables as Parameters

sabzam
Member Posts: 1,149
Can temporary tables be passed over as parameters to functions?
0
Comments
-
if you pass them by reference yes0
-
Can you kindly specify what by reference mean?0
-
-
Ah ok that was simple. Thanks for your immediate reply0
-
NOTE: As you probably know, passing a parameter byref means that when the procedure finish, it returns the modified value of the variable, so you can pass the temptable in the function without specifying "byref" but if you call the table after the function like this
clear(temptable); function a(temptable); temptable.get('OK'); ---Function a(temptable : tableyouwant) !!!not by ref temptable.key := 'OK'; temptable.insert;
you will get an error for an unsuccesful "get"
if you do thisclear(temptable); function a(temptable); ---Function a(temptable : tableyouwant) !!!not by ref temptable.key := 'OK'; temptable.insert; temptable.get('OK');
the "get" success, because you're in the same function. to pass the temptable outside you clearly have to doclear(temptable); function a(temptable); temptable.get('OK'); ---Function a(temptable : tableyouwant) !!!BY REF temptable.key := 'OK'; temptable.insert;
Guess it's clear0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions