Notice: Undefined offset: 2 in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 735
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[T_tblSmetki_Stavki_ITrig] ON [dbo].[tblSmetki_Stavki] FOR INSERT AS
SET NOCOUNT ON
/* * PREVENT INSERTS IF NO MATCHING KEY IN 'tblArtikli' */
IF (SELECT COUNT(*) FROM inserted) !=
(SELECT COUNT(*) FROM tblArtikli, inserted WHERE (tblArtikli.ID_Artikal = inserted.ssStavka))
BEGIN
RAISERROR 44447 'The record can''t be added or changed. Referential integrity rules require a related record in table ''tblArtikli''.'
ROLLBACK TRANSACTION
END
/* * PREVENT INSERTS IF NO MATCHING KEY IN 'tblSmetki' */
IF (SELECT COUNT(*) FROM inserted) !=
(SELECT COUNT(*) FROM tblSmetki, inserted WHERE (tblSmetki.ID_Smetka = inserted.ssSmetka))
BEGIN
RAISERROR 44447 'The recor