BAM email .p programs

Yahoo Archive
1
Yes. You can use 4GL FIND statements, etc. to bring in related data
(using the PartRev data that your BAM receives as a starting point).

e.g.

{ud/GlbAlert.i &TableName = "PartRev"}
Define variable PartDescription as character no-undo.

Find Part where part.company = partrev.company and part.partnum =
partrev.partnum no-lock no-error.
If available Part then do:
Assign PartDescription = Part.Description.
End.

Now you could include PartDescription in your e-mail body.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cooner_55421
Sent: Wednesday, February 09, 2011 9:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM email .p programs

Hi,

I have some simple BAM email alerts that include fields from the same
table the BAM is based on.
Is it possible to add fields from related tables?

For example, is there a way to add Part.Description to the .p program
example below?

Thanks


{ud/GlbAlert.i &TableName = "PartRev"}

/* Create the new body of the email */

ASSIGN Email-Text = "Testing email alerts " +
string(PartRev.Approved) + " for "
+ " ApprovedBy: " + string(PartRev.ApprovedBy)
+ " PartNum: " + string(PartRev.PartNum) + " Rev:
" +
string(PartRev.RevisionNum)



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

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
2
Sure. I'm doing this from memory so double check the syntax:


{ud/GlbAlert.i &TableName = "PartRev"}
Â
DEFINE VARIABLEÂ PartDesc AS CHARACTER NO-UNDO.
Find First Part Where Part.Company = PartRev.Company AND Part.PartNum =
PartRev.PartNum NO-LOCK NO-ERROR.
If Available Part Then PartDesc = Part.Description.
Â
/* Create the new body of the email */
Â
ASSIGN Email-Text = "Testing email alerts " + string(PartRev.Approved) + " for "
+ " ApprovedBy: " + string(PartRev.ApprovedBy)
+ " PartNum: " + string(PartRev.PartNum) + " Rev: " +
string(PartRev.RevisionNum) + " Part Description: " + PartDesc.





________________________________
From: cooner_55421 <cooner_55421@...>
To: vantage@yahoogroups.com
Sent: Wed, February 9, 2011 9:42:16 PM
Subject: [Vantage] BAM email .p programs

Â
Hi,

I have some simple BAM email alerts that include fields from the same table the
BAM is based on.
Is it possible to add fields from related tables?

For example, is there a way to add Part.Description to the .p program example
below?

Thanks

{ud/GlbAlert.i &TableName = "PartRev"}

/* Create the new body of the email */

ASSIGN Email-Text = "Testing email alerts " + string(PartRev.Approved) + " for "
+ " ApprovedBy: " + string(PartRev.ApprovedBy)
+ " PartNum: " + string(PartRev.PartNum) + " Rev: " +
string(PartRev.RevisionNum)







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