On 4/21/2012 3:11 AM, Gérard Lochon wrote: > ----- Original Message ----- > From: "Kurt Wendt"<[email protected]> > > Could you explain to me how this can work : > >> SELECT EDIHDR >> SCAN >> xCurrCUSTPO = CUSTPO >> xCurrORDER = ORDER >> SELECT OrderHdr >> IF !SEEK('TARGE'+xCurrCUSTPO) >> LOOP >> ENDIF >> SCAN REST FOR account+custpo+order = 'TARGE'+xCurrCUSTPO ********* !!! >> xExistingOrder = Order > as account+custpo+order is made of 3 fields, and 'TARGE'+xCurrCUSTPO is made > of 2 !
I used the full 3 fields that make up the Index - since that is how you Properly use Rushmore! And, generally speaking - the Customer Orders in the system usually have a unique PO# & Order # combination. > if you say "ok, i forgot to include + xcurrorder", why on the next line is > there an xexistingorder = order, > as this value is yet known as xcurrorder !! Nope - I did NOT forget the 3rd field. Lastly - this is all part of EDI Order conversion. When the order is brought in & converted - the data is put into an Order Header & Line temp files that match the same structure as the final Order DBF files. So - during initial conversion - the orders are actually given Fake/Temp Order #'s. So - if you convert the orders Again - you would need to match the converted orders against Pre-existing Orders by way of the Cust PO#. That makes sense. And - in the end - the user can bail out from posting the order into the system - but, my special code allows special extra data fields to be matched up & updated into the existing orders - without actually posting the full order data back into the system - there by solving a particular problem we have been having! -K- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
