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
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]
>