JDETECHIE
Active Member
Hi ALl,
I am getting weired problem.I have created table trigger on custom table for adudit log perpose.Triggers will fire after delete,update,insert and write record in to another custom log file.some body created a application using this file uses.Through this application if i insert and update it is inserting proper record in to audit log file, but the problem is if i delete a record through this application it is inserting wrong record in to log file.Problem is when i delete it is not getting data base values(all fildes are balnk), so it is not inserting values.
I created another dummy application and deleted from there it is working fine.
what is the problem why it is not wotking from other existing applicaiton. am going mad gurus help me out.
xe, sp17.1, update 4. sql
I am getting weired problem.I have created table trigger on custom table for adudit log perpose.Triggers will fire after delete,update,insert and write record in to another custom log file.some body created a application using this file uses.Through this application if i insert and update it is inserting proper record in to audit log file, but the problem is if i delete a record through this application it is inserting wrong record in to log file.Problem is when i delete it is not getting data base values(all fildes are balnk), so it is not inserting values.
I created another dummy application and deleted from there it is working fine.
what is the problem why it is not wotking from other existing applicaiton. am going mad gurus help me out.
xe, sp17.1, update 4. sql
