I have the following code installed on my database.
Create Trigger CFXSOUpdate
If Update(SOM_DefaultRequiredDate) or Update(SOM_DefaultShipMethod)
Declare @Body varchar (100)
Set @Body= 'The Required Date or Ship Method has been changed'
@recipients = 'ARaedeke@Tri-Optic.com',
@subject = 'Sales Order Change',
@message = '@Body'
The trigger fires when the fields are updated, but the email message only has the word
@body in it. No sign of the message I intend to send.
Thanks for the help,
February 5, 2009 6:43 PM
February 17, 2009 11:34 PM