June 5, 2002 at 5:31 pm
I have two tables: tblData and tblChangeLog.
Data is stored in tblData and changes to that data is recorded in tblChangeLog. I can easily capture the inserts and updates, but when I delete a record, the record number disappears before the DELETE trigger can capture it. Any suggestions?
Thanks. PC
June 5, 2002 at 7:00 pm
You should have access to all deleted info (minus text cols) in the logical deleted table inside a delete trigger.
Andy
June 5, 2002 at 8:10 pm
I agree with Andy the field and data should still be available in the trigger. Can you post what you have for your trigger, maybe there is something going wrong.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply