3154227 - Trigger not working as expected. - SAP ASE

• Trigger set to delete records, is not working as expected. 
• When used with a set rowcount 1 -- it works as expected and fires the trigger - to rollback.
• When set rowcount 0 -- it does not work as expected - it does not fire the trigger and data is deleted.
  create trigger mytable_delete 
  on mytable 
  for delete as
  set rowcount 0 
  if  (select count(*)
      from deleted, mytable 
      where mytable.LoginName = deleted.LoginName and deleted.LoginName in ('login1','login3','login2')) > 0
    begin 
      rollback transaction 
      print "You are not allowed to delete login1 , login3 or login2 entries from mytable , Contact Engineering Team"
    end
  go

SAP Adaptive Server Enterprise (ASE) 16.0

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To