4GL Code Question (Looping)

Yahoo Archive
1
Thanks Brian! This should get me on the right path.




________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Monday, July 20, 2009 1:06:47 PM
Subject: RE: [Vantage] 4GL Code Question (Looping)

Â
find PODetail where (PODetail.Company = POHeader.Company) and (PODetail.PONum = POHeader.PONum) no-lock no-error.
for each PODetail of POHeader:
POAmount = POAmount + (PODetail.DocUnitCo st * PODetail.OrderQty) .
end.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of melissa hietala
Sent: Monday, July 20, 2009 12:45 PM
To: vantage@yahoogroups .com
Subject: [Vantage] 4GL Code Question (Looping)

What is the proper 4GL code for looping through lines? For example, say I wanted to loop through each line of a PO, and get a sum of the quantity of parts that are purchased for the entire PO, how would I accomplish this? I need to create a BPM that uses this type of functionality.

Thank you,
 Dustin Biniek
UMC, Inc.
DustinB@ultramc. com

[Non-text portions of this message have been removed]

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links







[Non-text portions of this message have been removed]
2
What is the proper 4GL code for looping through lines? For example, say I wanted to loop through each line of a PO, and get a sum of the quantity of parts that are purchased for the entire PO, how would I accomplish this? I need to create a BPM that uses this type of functionality.

Thank you,
 Dustin Biniek
UMC, Inc.
DustinB@...




[Non-text portions of this message have been removed]
3
find PODetail where (PODetail.Company = POHeader.Company) and (PODetail.PONum = POHeader.PONum) no-lock no-error.
for each PODetail of POHeader:
POAmount = POAmount + (PODetail.DocUnitCost * PODetail.OrderQty).
end.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of melissa hietala
Sent: Monday, July 20, 2009 12:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 4GL Code Question (Looping)

What is the proper 4GL code for looping through lines? For example, say I wanted to loop through each line of a PO, and get a sum of the quantity of parts that are purchased for the entire PO, how would I accomplish this? I need to create a BPM that uses this type of functionality.

Thank you,
 Dustin Biniek
UMC, Inc.
DustinB@...




[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links