distal-attribute
distal-attribute
distal-attribute
distal-attribute

SQL Logging - Log Delete Results Too?

User, date Message
Written by muzza4
7 years ago
Category: General
51 posts since Mon, 04 Dec 06
Hi Anse,

With logging turned on we see in the log

Update Example
---------------------
[2007-12-21 10:36:25] UPDATE `noticeboard` SET `header`='Test Message',`displayTo`='2006-12-09 12:55:00',`deleted`='Y',`created`='2006-10-10 01:55:18',`created_by`='2' WHERE `Id`=188

Insert Example
------------------------
[2007-12-21 10:42:57] INSERT INTO `clubsport` (`Id`, `club_id`, `sport_id`, `federation_club_id`) VALUES (1,1,1,0), (2,2,1,0), (3,3,1,0), (4,11,1,0), (5,12,1,0), (7,14,1,0), (17,38,1,0), (22,74,1,0), (40,101,1,0), (41,103,2,0), (42,104,1,0), (67,108,1,0), (68,109,1,0), (69,110,1,0), (94,116,1,0), (96,118,1,0), (99,122,1,0), (149,13,1,0), (150,15,1,0), (151,16,1,0), (152,17,1,0), (153,18,1,0), (154,19,1,0), (155,20,1,0), (156,22,1,0), (157,28,1,0), (158,29,2,0), (159,49,2,0), (160,50,2,0), (167,130,1,0), (172,135,1,0)

Delete Example
--------------------------
[2007-12-21 10:42:53] delete from clubsport


Why does the delete not show what was deleted, the updates and inserts give an excellent log.

Regards
Muzza
Written by ansgar
7 years ago
4940 posts since Fri, 07 Apr 06
Oh DELETEs also get into the log as you expect. This DELETE command was surely not executed while you were deleting a row from a grid view, probably you executed it by query or by rightclicking a table and then clicking "Empty..."
 

Please login to leave a reply, or register at first.