Dataport (GET VALUEs)
jjmmss1
Member Posts: 32
I have a table TABLE1 which has 3 fields (1) Barcode No. (2) Item Desc (3) Qty.
(1) Barcode No. field is populated with 100, 200, 300, 400 such values
(2) Item Desc field is also populated against each Barcode no.
(3) Qty field is blank.
I want to insert values into Qty field with values from a text.txt file which has few Barcode No. and each Barcode No. its has a Qty(value).
I want create a dataport such that when inserting data, it search the Barcode No. first and IF TABLE1. Barcode No.:= text.txt.Barcode No THEN Qty(values) will be inserted into the TABLE1.Qty.
How can I do It?
(1) Barcode No. field is populated with 100, 200, 300, 400 such values
(2) Item Desc field is also populated against each Barcode no.
(3) Qty field is blank.
I want to insert values into Qty field with values from a text.txt file which has few Barcode No. and each Barcode No. its has a Qty(value).
I want create a dataport such that when inserting data, it search the Barcode No. first and IF TABLE1. Barcode No.:= text.txt.Barcode No THEN Qty(values) will be inserted into the TABLE1.Qty.
How can I do It?
0
Comments
-
If I understood well your need, that behaviour should be standard.
But the primary key of your table must be "Barcode No." for it to work.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!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
- 322 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