Action type with triggers? 1

[russland]

Hi all,

I want to save the DML action on this table to a Log table. Do you know how I can determine what DML-Action was triggered? INSERT, UPDATE OR DELETE?

Any hint is welcome, thanks.


CREATE TRIGGER ListenToEventsOnUsers on A_Users
AFTER INSERT, UPDATE, DELETE
AS
INSERT A_Log
(DBUser, ActionType, LoggedObject)
VALUES (CURRENT_USER, ACTIONTYPE , 'A_Users')

 

[PHV]

Why not create a trigger for each action ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[fredericofonseca]

best and correct way would be to create a trigger for each action.

But the following may help you. untested.

select @old_count = select count(*) from deleted
select @new_count = select count(*) from inserted

If doing a insert @old_count should be zero
If doing a delete @new_count should be zero
If doing a update both counts should not be zero


As I said it is completely untested and it may not be the way it works. try it.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com