I have an
EvidenceTimeStamp
table that is triggered with data when the case table has data inserted into it.
EvidenceTimeStamp
:
- CaseID
- EvidenceNum
- EvidenceType
- Evidence_Initiated_Timestamp
- Evidence_Returned_Timestamp
I created a trigger to fill the first four columns of data whenever a new case is inserted in the case table and it creates a timestamp on Evidence_Initiated_Timestamp
when this happens.
However, I need to create a closing timestamp when the process is complete. I wanted to do this by my Outbound Ship Table- everytime the Attribute (bit value) Outbound_Item_Recevied
is changed from false to true (or 0 to 1) I want it to initate a timestamp on the Evidence_Returned_Timestamp
column in my EvidenceTimeStamp
table that matches the corresponding CaseID
and EvidenceNum
.
Note: the EvidenceTimeStamp
table does not have a primary key or foreign key technically... the CaseID
is primary key in the Case
table and EvidenceNum
is an attribute in the Evidence
Table. This is a "trigger" table so it really doesn't have its own specific data, it's just filling data from other tables.
Any idea of how to do this?
Also, other quick question, how do I get bit values to show "True" or "False" instead of 1 or 0? Thank you!!
Asked by Alee
(47 rep)
Jun 8, 2017, 03:10 PM
Last activity: Aug 6, 2025, 07:09 AM
Last activity: Aug 6, 2025, 07:09 AM