Thank you very much! This worked great.
Cathy
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Anstey
Sent: Tuesday, April 16, 2013 6:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM Help - Find Each - need a loop
Instead of FIND FIRST use the following:
FOR EACH ShipUPS where ShipUPS.Company = ttShipHead.Company
and ShipUPS.PackNum =
ttShipHead.PackNum
and ShipUPS.EmailAddress <>
'shipping@... <mailto:%26%2339%3Bshipping%40xxxxxx.com>
<mailto:%26%2339%3Bshipping%40xxxxxx.com> ' no-lock
: /* <- put a colon here. */
/* do stuff for each ShipUPS here */
END. /* End the FOR EACH loop with an end statement (don't forget the
period) */
Also it looks like you want to use the ttShipHead as the selection
criteria, so it looks backwards in your statement below. I put it in
the standard format above.
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of cathyattechnologicsys
Sent: Monday, April 15, 2013 8:15 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BPM Help - Find Each - need a loop
This is what I have -
Find first ShipUPS where ttShipHead.Company = ShipUPS.Company
and ttShipHead.PackNum = ShipUPS.PackNum
and ShipUPS.EmailAddress <> 'shipping@...
<mailto:%26%2339%3Bshipping%40xxxxxx.com>
<mailto:%26%2339%3Bshipping%40xxxxxx.com> ' no-lock.
I would like to find each and have it loop through but, I don't know
that syntax.
Any help would be appreciated.
Thank you,
Cathy
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Cathy
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Anstey
Sent: Tuesday, April 16, 2013 6:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM Help - Find Each - need a loop
Instead of FIND FIRST use the following:
FOR EACH ShipUPS where ShipUPS.Company = ttShipHead.Company
and ShipUPS.PackNum =
ttShipHead.PackNum
and ShipUPS.EmailAddress <>
'shipping@... <mailto:%26%2339%3Bshipping%40xxxxxx.com>
<mailto:%26%2339%3Bshipping%40xxxxxx.com> ' no-lock
: /* <- put a colon here. */
/* do stuff for each ShipUPS here */
END. /* End the FOR EACH loop with an end statement (don't forget the
period) */
Also it looks like you want to use the ttShipHead as the selection
criteria, so it looks backwards in your statement below. I put it in
the standard format above.
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of cathyattechnologicsys
Sent: Monday, April 15, 2013 8:15 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BPM Help - Find Each - need a loop
This is what I have -
Find first ShipUPS where ttShipHead.Company = ShipUPS.Company
and ttShipHead.PackNum = ShipUPS.PackNum
and ShipUPS.EmailAddress <> 'shipping@...
<mailto:%26%2339%3Bshipping%40xxxxxx.com>
<mailto:%26%2339%3Bshipping%40xxxxxx.com> ' no-lock.
I would like to find each and have it loop through but, I don't know
that syntax.
Any help would be appreciated.
Thank you,
Cathy
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]