Dataport (GET VALUEs)

jjmmss1jjmmss1 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?

Comments

  • krikikriki Member, Moderator Posts: 9,118
    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!


Sign In or Register to comment.