CREATE TRIGGER BELGENOON LG_999_01_INVOICEAFTER INSERT,UPDATEAS
DECLARE @INVLOGI INTDECLARE @INVDOCODE NVARCHAR(11)DECLARE @TRCODE SMALLINT
SELECT @INVLOGI=LOGICALREF FROM insertedSELECT @INVDOCODE=DOCODE FROM insertedSELECT @TRCODE=TRCODE FROM inserted
IF (@TRCODE=8)
BEGINUPDATE LG_999_01_INVOICE SET DOCODE=” WHERE LOGICALREF=@INVLOGIEND
Logo SQL
Comments are closed