Method directive on UDxx.Update
execute abl code
Something like this.
Greg
For each ttUD15 where (ttUD15.rowmod = 'A' or ttUD15.rowmod = 'U') and ttUD15.Company = cur-comp.
For each Part where Part.Company = ttUD15.Company and Part.PartNum = ttUD15.key1 no-error.
If Available Part then Do:
assign part.character01 = UD15.key3.
find PartCost where PartCost.Company = ttUD15.Company and PartCost.PartNum = ttUD15.key1 and PartCost.CostID = ttUD15.key2 no-error.
If Not available PartCost then do:
Message "DEBUG Adding Part Cost record for " + ttUD15.key1.
Create PartCost.
PartCost.Company = ttUD15.Company.
PartCost.PartNum = ttUD15.key1.
PartCost.CostID = ttUD15.key2.
Release PartCost.
End.
End.
End.
End.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mitch Hermes
Sent: Thursday, July 18, 2013 6:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] DMT for entering Supplier Containers
Update method?
--
Mitch Hermes
Estimator
[9A1C6986-3A3F-4B80-BA78-63C7490CE825]
T +1 425 776 4946 | F +1 425 491 8200
A 11831 Beverly Park Road Building D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com/> | Like Us On Facebook<http://www.facebook.com/electricmirror> | Follow Us On Twitter<http://www.twitter.com/electricmirror>
NOTE: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use.
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Greg Payne
Sent: Wednesday, July 17, 2013 7:19 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] DMT for entering Supplier Containers
I use a UD table to bring in records and then populate other tables via the update method with that data.
Greg
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of mitch
Sent: Wednesday, July 17, 2013 4:55 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] DMT for entering Supplier Containers
Does anybody know of a way utilize DMT to create new Supplier Container records. I know there isn't a listing for those tables directly, but I thought some of the smarties in this group may have a back door.
-Mitch
________________________________
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
________________________________
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
[Non-text portions of this message have been removed]
execute abl code
Something like this.
Greg
For each ttUD15 where (ttUD15.rowmod = 'A' or ttUD15.rowmod = 'U') and ttUD15.Company = cur-comp.
For each Part where Part.Company = ttUD15.Company and Part.PartNum = ttUD15.key1 no-error.
If Available Part then Do:
assign part.character01 = UD15.key3.
find PartCost where PartCost.Company = ttUD15.Company and PartCost.PartNum = ttUD15.key1 and PartCost.CostID = ttUD15.key2 no-error.
If Not available PartCost then do:
Message "DEBUG Adding Part Cost record for " + ttUD15.key1.
Create PartCost.
PartCost.Company = ttUD15.Company.
PartCost.PartNum = ttUD15.key1.
PartCost.CostID = ttUD15.key2.
Release PartCost.
End.
End.
End.
End.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mitch Hermes
Sent: Thursday, July 18, 2013 6:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] DMT for entering Supplier Containers
Update method?
--
Mitch Hermes
Estimator
[9A1C6986-3A3F-4B80-BA78-63C7490CE825]
T +1 425 776 4946 | F +1 425 491 8200
A 11831 Beverly Park Road Building D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com/> | Like Us On Facebook<http://www.facebook.com/electricmirror> | Follow Us On Twitter<http://www.twitter.com/electricmirror>
NOTE: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use.
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Greg Payne
Sent: Wednesday, July 17, 2013 7:19 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] DMT for entering Supplier Containers
I use a UD table to bring in records and then populate other tables via the update method with that data.
Greg
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of mitch
Sent: Wednesday, July 17, 2013 4:55 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] DMT for entering Supplier Containers
Does anybody know of a way utilize DMT to create new Supplier Container records. I know there isn't a listing for those tables directly, but I thought some of the smarties in this group may have a back door.
-Mitch
________________________________
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
________________________________
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
[Non-text portions of this message have been removed]