How to combine the field value and store in single variable?

Aravindh_Navision
Member Posts: 258
Hi Friends,
From Cust. Ledger Entry table, there is a Document No. field. The values are:
I need to store the combination of these values into one variable and export it in dataport. That is:
How to do this? Can anyone help to achieve this?
Thanks in advance,
Aarvi.
From Cust. Ledger Entry table, there is a Document No. field. The values are:
Document No. A001 A002 A003 A004
I need to store the combination of these values into one variable and export it in dataport. That is:
varX := A001 + A002 + A003 + A004;
How to do this? Can anyone help to achieve this?
Thanks in advance,
Aarvi.
0
Comments
-
What if you have hundreds of doc no's?
The value created would be too large at some point and cause an error.
Has you looked into streaming an output to text. And appending the string with an additional value each time?
https://msdn.microsoft.com/en-us/librar ... 70%29.aspx
viewtopic.php?f=23&t=46393&view=next0 -
Thanks Savatage for your reply.
I anticipated there could be an error because of having hundreds od Document nos. I asked the business and they said there will not be hundreds of Document nos.
So do you have any idea to accomplish this?0
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