Zabrana Sync starih prometa

create trigger [dbo].[_Kontrola] on [dbo].[tHE_MoveItem]
for insert
as
set nocount on
declare @ErrMsg varchar(255)

if dbo.fPA_GetConInfoRC(2) = 1
return

if exists (
select g.acDocType, m.acSetOfItem, d.acShortDocName
from tHE_MoveItem p
inner join inserted i on p.acKey = i.acKey and p.anNo = i.anNo
inner join tHE_Move g on p.acKey = g.acKey
inner join _Postavke d on g.acDocType = d.acDocType and d.acShortDocName not like ''
inner join tHE_SetItem m on p.acIdent = m.acIdent
where m.acSetOfItem <> d.acShortDocName)
begin
set @ErrMsg = 'Pokusavate unijeti poziciju koja nije dozvoljena, artikli 200 i 500 ne mogu se mijenjati'
raiserror(@ErrMsg, 16, 1)
rollback
end
GO