V8 bam

I am just trying to find a way to get an event trigger to fire an
e-mail. We use them extensively
In 6.1. When Epicor decided to go to the DotNet environment did they
also decide to scrap the
User-defined event trigger options?


>We are still testing V8 at our company and have not written any BAMs
yet, but I think one problem is you are trying to
>run Progress code in a C# .NET environment. You need Progress
prowin32.exe to run the code below. I'm not aware of any
>way to run it otherwise. If you found one, please let me know. We have
a bunch of User Defined programs we need to
>convert.

Mark Olson
Programmer/DBA
TEAM Industries
763-691-2381
markolson@...
Has anyone created an event trigger using the BAM in V8 that fires an
e-mail.
I tried the following and all I get is 4GL stop errors.

CONNECT mfgsys -db \\tsevan8\epicor\mfgsys80\db\mfgsys.db -N TCP -H
TSEVAN8 -S 8010 NO-ERROR.
DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
FIND JobHead WHERE JobDtl.Company = JobHead.Company AND
JobDtl.JobNum = JobHead.JobNum NO-LOCK.
IF JobHead.JobReleased = YES THEN DO:
ASSIGN Email-to = "dick.plaman@...".
MESSAGE = "Job Number : " + STRING(JobHead.JobNum) + " ~n"
+ "Part Number : " + JobDtl.PartNum.
END.

ELSE DO:
RETURN "Cancel Send":U.
END.
DISCONNECT mfgsys.




[Non-text portions of this message have been removed]
We are still testing V8 at our company and have not written any BAMs
yet, but I think one problem is you are trying to run Progress code
in a C# .NET environment. You need Progress prowin32.exe to run the
code below. I'm not aware of any way to run it otherwise. If you
found one, please let me know. We have a bunch of User Defined
programs we need to convert.
One other thing, it looks like your properties of the FIND command
may be backwards. Shouldn't it be
'where JobHead.Company = JobDtl.Company
and JobHead.JobNum = JobDtl.JobNum'
in order to find the Jobhead record with Jobdtl data? I wouldn't
think it would work otherwise.

Mark Olson
Programmer/DBA
TEAM Industries
763-691-2381
markolson@...

--- In vantage@yahoogroups.com, "PLAMAN DICK" <dick.plaman@...>
wrote:
>
> Has anyone created an event trigger using the BAM in V8 that fires
an
> e-mail.
> I tried the following and all I get is 4GL stop errors.
>
> CONNECT mfgsys -db \\tsevan8\epicor\mfgsys80\db\mfgsys.db -N TCP -H
> TSEVAN8 -S 8010 NO-ERROR.
> DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
> FIND JobHead WHERE JobDtl.Company = JobHead.Company AND
> JobDtl.JobNum = JobHead.JobNum NO-LOCK.
> IF JobHead.JobReleased = YES THEN DO:
> ASSIGN Email-to = "dick.plaman@...".
> MESSAGE = "Job Number : " + STRING(JobHead.JobNum)
+ " ~n"
> + "Part Number : " + JobDtl.PartNum.
> END.
>
> ELSE DO:
> RETURN "Cancel Send":U.
> END.
> DISCONNECT mfgsys.
>
>
>
>
> [Non-text portions of this message have been removed]
>