Thanks! Well at least now I can stop trying to figure out what I did wrong. In Vantage 6.1 not all tables were available but it was easy to manage because you could not create a BAM at all if the table was unavailable. When I saw these new tables as an option in 8.03 I was so excited to think they expanded BAM functionality to include more tables. What a disappointment. Well, I ended up using a SQL trigger to send my email alert but it would have been nice to do it in Vantage.
Thanks,
Aimee
Thanks,
Aimee
--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> Bams do not work on all tables and all fields. I battled with support
> over this many times, and they freely admitted as such. I can accept
> that it doesn't work on all of them, what I did find hard to accept was
> that they couldn't produce a simple list of what tables and fields were
> or were not eligible.
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 3111
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of aimee.grebe
> Sent: Tuesday, April 20, 2010 8:26 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Progress .p programs for BAM email alerts
>
>
>
>
>
> Thank you to everyone who sent me files. Much appreciated! I did run
> into one more snag trying to set this up. I am trying to track changes
> to the DMRHead and DMRActn tables but could not get Vantage to send an
> Email alert. All works perfectly on tables like OrderRel and JobHead so
> I know I have the email portion configured correctly. I even tried the
> PartTran table instead with the same result. I can get it to write to
> the ChangeLog but no emails are fired off at all.
>
> Anyone else had issues with BAMs working only on some tables?
>
> Thanks,
> Aimee
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "aimee.grebe" <aimee.grebe@> wrote:
> >
> > Does anyone have any experience writing .p programs to attach to BAM
> email alerts? I am not a Progress person (My experience is VB.Net) but
> once upon a time I took a code sample and was able to turn it into what
> I needed by copying the Progress syntax.
> >
> > What I'm ultimately trying to do is attach an "Additional Alert
> Procedure" to a BAM email alert so that I can include specific field
> values in the email body.
> >
> > If anyone has any samples they could send to help me get started it
> would be a big help.
> >
> > Thanks in advance,
> > Aimee
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>