Recieve empty xml without data when update/delete doesn't match any records

[MitkoDMTR]

If you perform update/delete sql query over the table and no records are affected, the message that we recieve is and NotificationType property has value None. Maybe is a good idea if user is not specify None notification type to skip sending such messages from trigger or rising the event.

[dyatchenko]

Hi @MitkoDMTR,

Thanks for the remark. It is a good idea and will be implemented as soon as possible.

Thanks, Dmitrii

[asulwer]

could this be explained better? what i think you are saying is when an update/delete occurs and no records are changed the NotificationType is None? and you want to skip the Notification Event if NotificationType is None?

If this isnt fixed then i can work on it.

[dimitarlazarovevolution]

First sorry for late response.

Yes, this is exactly what I say - if records are not affected by update/delete, we get notification of type None and xml like "".

On our last project we changed the trigger not to send message to queue. It is possible to do it on c# side, but we decided not to send "empty" messages through the broker.