Good news is that you are right, using those steps I was able to get the constraints in place and they are working correctly on the dbase side.

However the GUI...

I tried that, also tried the variation below and it still allows me to save the order with a null field

ALTER TABLE dbo.oe_hdr ADD CONSTRAINT

Validate_Freight_Code CHECK (freight_code_uid >0 AND...

Re 2 - the freight code isn't a mandatory field in the app and the users are forgetting to fill it out - causes major headaches down the road. Really...

Thanks for replying -here is what I know so far:

1 - I don't care about updates, they need to have this code in place when they save for the first...

I'm now attempting:

EXEC msdb.dbo.sp_send_dbmail

@profile_name ='Alerts',

@recipients=N'bjohnson@cummins-wagner.com',

@body='Message Body',

@subject ='Message Subject',

@query = 'select

p21_invoice_amt_remaining_view.invoice_no,

p21_invoice_amt_remaining_view.amt_remaining_frominv,

...

That query worked - so if we set it up that way, how do I handle the @query part of the execution of the email?

So do you mean that the where section should be:

where

p21_view_invoice_hdr.paid_in_full_flag = ''N''

AND p21_view_invoice_hdr.disputed_flag = ''N''

AND p21_invoice_amt_remaining_view.amt_remaining_frominv > ''4999.99''

AND p21_view_invoice_hdr.invoice_date < (select dateadd(d,-30,CURRENT_TIMESTAMP))

Where anything with single...

Thanks for the replies guys - I also found that

(select dateadd(d,-90,CURRENT_TIMESTAMP))

works as well

(banging head against desk)

I should have caught that - when I tried before I had a typeo in the script and figured that the problem WASN'T me (guess I was...

That's a good question, let me clarify - "tax_group_id" is the display name for the tax group and can be change via the apps management gui as well. I just...

OK, new quirk I just realized.

tax_group_ID is limited to 10 characters so if I run this it's going to give me an error.

How can this script be modified to...

Jeff Moden (3/7/2008)

---

Hold the phone... how do you know that the only things that start with VA are VA- as in Virginia... never do an update of this nature without...

I see what you mean about not running the email directly from the trigger. I'm not sure how to go about setting up temp tables and running it as a...

Actually it turns out that my original trigger was too precise. Our app includes hr/min/sec in the date records so 01/01/08 really becomes 01/01/08 12:00:00

To get around that problem I...

Thanks for the feedback Chad, I'm going to try re-writing the trigger to point at the tables rather than the view and see what happens.