BAM 6.10 Blank Title 52160

Thank you both! I tried this one with OLD in front, and it seems to
work perfectly. I will use the "?" on some others that am working on...

Thanks!
Ben

--- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@...> wrote:
>
> Try:
> IF OLDOrderDtl.NeedByDate > 01/01/2000
> This will only fire if the NeedByDate has previously been filled and
> something being changed.
> You can use the same logic if it's not the NeedBy field you are
trying to
> look at. Just use OLD in front of the field and test to be sure that a
> value was assigned to it previously. If it was empty, it's a new
record and
> don't send the alert.
> This should lead you in a direction.
> Good luck,
> Aaron Hoyt
> Vantage Plastics
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of
> bbelzer42
> Sent: Tuesday, October 03, 2006 3:23 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAM 6.10
>
>
> I am setting up an alert, and I was wondering if I could get some
help.
>
> I set an alert that tells me if someone has changed the "Need By" date
> in the OrderDtl table.
>
> I only want to have an alert if something has changed. I do get those
> alerts, but I also get alerts when a "New Record" is created. I don't
> wish to see those.
>
> Is there any way to not have those sent?
>
> I was thinking of creating a .p that states "if the needbydate field
> is null (empty) then don't send an email". Below is my code, but it
> is invalid.
>
> Any help would be GREAT!!!
>
> {ud/GlbAlert.i &TableName = "OrderDtl"}
>
> DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
>
> IF Mfgsys.OrderDtl.NeedByDate <> ''
>
> THEN DO:
> ASSIGN Email-Text = "Need By Date has been entered or changed.~n~n"
> + "Order: " + string(Mfgsys.OrderDtl.OrderNum)
> + "~n~nNeed by Date: " + string(Mfgsys.OrderDtl.NeedByDate).
>
> END.
>
> ELSE DO:
> Return "Cancel Send":U.
>
> END.
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I am setting up an alert, and I was wondering if I could get some help.

I set an alert that tells me if someone has changed the "Need By" date
in the OrderDtl table.

I only want to have an alert if something has changed. I do get those
alerts, but I also get alerts when a "New Record" is created. I don't
wish to see those.

Is there any way to not have those sent?

I was thinking of creating a .p that states "if the needbydate field
is null (empty) then don't send an email". Below is my code, but it
is invalid.

Any help would be GREAT!!!

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

DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.

IF Mfgsys.OrderDtl.NeedByDate <> ''

THEN DO:
ASSIGN Email-Text = "Need By Date has been entered or changed.~n~n"
+ "Order: " + string(Mfgsys.OrderDtl.OrderNum)
+ "~n~nNeed by Date: " + string(Mfgsys.OrderDtl.NeedByDate).

END.

ELSE DO:
Return "Cancel Send":U.

END.
a null value in Progress is represented by a "?"

if Mfgsys.OrderDtl.NeedByDate <> ?

But I'm not sure that will resolve your problem. I don't think you can check to see what the previous value was changed from in the BAM. However if it's a BAM from a new order without any needbydates that you don't want to receive, then the ? will prevent those from being sent.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of bbelzer42
Sent: Tuesday, October 03, 2006 2:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM 6.10



I am setting up an alert, and I was wondering if I could get some help.

I set an alert that tells me if someone has changed the "Need By" date
in the OrderDtl table.

I only want to have an alert if something has changed. I do get those
alerts, but I also get alerts when a "New Record" is created. I don't
wish to see those.

Is there any way to not have those sent?

I was thinking of creating a .p that states "if the needbydate field
is null (empty) then don't send an email". Below is my code, but it
is invalid.

Any help would be GREAT!!!

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

DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.

IF Mfgsys.OrderDtl.NeedByDate <> ''

THEN DO:
ASSIGN Email-Text = "Need By Date has been entered or changed.~n~n"
+ "Order: " + string(Mfgsys.OrderDtl.OrderNum)
+ "~n~nNeed by Date: " + string(Mfgsys.OrderDtl.NeedByDate).

END.

ELSE DO:
Return "Cancel Send":U.

END.







[Non-text portions of this message have been removed]
Try:
IF OLDOrderDtl.NeedByDate > 01/01/2000
This will only fire if the NeedByDate has previously been filled and
something being changed.
You can use the same logic if it's not the NeedBy field you are trying to
look at. Just use OLD in front of the field and test to be sure that a
value was assigned to it previously. If it was empty, it's a new record and
don't send the alert.
This should lead you in a direction.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
bbelzer42
Sent: Tuesday, October 03, 2006 3:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM 6.10


I am setting up an alert, and I was wondering if I could get some help.

I set an alert that tells me if someone has changed the "Need By" date
in the OrderDtl table.

I only want to have an alert if something has changed. I do get those
alerts, but I also get alerts when a "New Record" is created. I don't
wish to see those.

Is there any way to not have those sent?

I was thinking of creating a .p that states "if the needbydate field
is null (empty) then don't send an email". Below is my code, but it
is invalid.

Any help would be GREAT!!!

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

DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.

IF Mfgsys.OrderDtl.NeedByDate <> ''

THEN DO:
ASSIGN Email-Text = "Need By Date has been entered or changed.~n~n"
+ "Order: " + string(Mfgsys.OrderDtl.OrderNum)
+ "~n~nNeed by Date: " + string(Mfgsys.OrderDtl.NeedByDate).

END.

ELSE DO:
Return "Cancel Send":U.

END.






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