column does not allow nulls. UPDATE fails. 1

[nevets72]

Hi....I'm trying to delete a record from a table, but I get the following message:

Attempt to insert the value NULL into column 'Employee_Type_ID', table 'staftrak.dbutlook_Total'; column does not allow nulls. UPDATE fails.
Command has been aborted.

The column 'Employee_Type_ID' is an integer field, and it does not allow NULLS, which I'm assuming is why I get the above message. However, I'm not trying to INSERT.....I want to DELETE, so I'm not sure:

A) Why the message I get back refers to an INSERT?
B) How can I remove the record from the table?

Thanks!

 

[AWithers]

Can you supply the code you are trying to run?

Andy

 

[clapag22]

Sounds like there may be a delete trigger on the table that's trying to do an update...

 

[nevets72]

That's it.....I checked the table, and it does have a trigger! I don't know how I overlooked that. Thanks guys!