Logging deletions

[Elroacho]

Does anyone know how to log when a record has been deleted from a table. I'm using Interbase 7 and I need to know who, when and what if possible.

Cheers.

 

[PatrickIRL]

<a href=

http://www.tek-tips.com/viewthread.cfm?qid=936573&page=1>thread756-936573</a>

 

[Elroacho]

I'm not sure this is what I'm after. The reponse on the post you are refering to helped me with what I wanted then but this is a different situation. What I need is a log that is created when a user deletes a recored from a given table. I know I could write a trigger for the delete on that table and just copy the recdord to a new table but I dont know how I would capture who made the delete.

Any thoughts.......

Cheers.

 

[badukist]

I have separate log tables , with extra columns updated from system variables current_user, current_timestamp

 

[Elroacho]

So Basically I can write a trigger on the table I want to watch, and copy the deleted record along with the above metioned variables. Sweet! I'll give it a try.

Cheers,
YNWA,
Kevin.