Click here to Skip to main content
16,017,279 members

Comments by vivek murli (Top 34 by date)

vivek murli 3-Dec-14 3:07am View    
Thanks DamithSL will give it a try
vivek murli 26-Nov-14 23:12pm View    
Thanks Robert.Will give it a try
vivek murli 23-Nov-14 10:05am View    
@Shweta N Mishra : I am sorry but I am not understanding your question.Are you asking about update table LeadMasters(On which trigger has been created)? If yes I have not written the update query which I guess could be the possible mistake.
The problem however with the above trigger was that If I made any changes to the Lead Masters table,It does not show me the row which has been modified or updated and it always stores the information Remark Note Modified or updated in table Lead Masters when I have not updated or modified that field.
Can you suggest modifications to the trigger so that it catches the rows that have been modified/updated?

I hope my doubt is clear.If not do let me know

Thanks
vivek murli 22-Nov-14 2:56am View    
@Shweta N Mishra Solution?
vivek murli 21-Nov-14 22:43pm View    
Thanks for replying guys

@Tomas and Shweta

The update statement is this
IF UPDATE(RemarkNote)
set @Audit_Action='Remark Note Modified or Updated'

In case of each update trigger,whatever you update in a table,the last update statement is executed like the one I have written above