Triggers III what,how,where,when ???

[Greg25]

Well I tried the last one and got no response from that i tried messing around with diff fields diff joins diff columes from the old one and was doining some good damage to my data bases the sofware i us to acess the sql server is call Job Manager & Virtual Ticket from Meta - comm the only sugjestion was to create the trigger I am also working with MS Access witch was great for creating reports and pulling the info off the server

this stuff is realy confussing i wish i took some computer training that may have been helpfull

sorry about my spelling i just barly made it through HS
if there is any one with a suggestion to what i could do i would be grately appretcati its also not the end of the world if the grils that i have been setting this up for to type the date in either

the hardist part was to be able to export the invoice info and import that into Quickbooks that was tough compaired to a trigger i thought

thanks again for all of your help

 

[Cagliostro]

What do you mean the last one? John Fill

ivfmd@mail.md

 

[Greg25]

This is what i have been trying to work with


Create Trigger status_date_change ON oder_entry
 For Update As
 If Update Last_Cost_Center_Code
   Begin
      Update order_entry_1 Set Status_date = getdate()
    From order_entry_1 Inner Join Inserted
   On order_entry_1.job_number = inserted.job_number

 

[tlbroadbent]

I'm not clear on the problem. Do you get an error? What is the message? Does it happen when you try to create the TRIGGER or when you update the table?

It appears the syntax is almost correct in your trigger.

Create Trigger status_date_change ON oder_entry
For Update As
If Update (Last_Cost_Center_Code)
Begin
Update order_entry_1 Set Status_date = getdate()
From order_entry_1 Inner Join Inserted
On order_entry_1.job_number = inserted.job_number
End
Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot