sql, trigger update
CREATE TRIGGER [jurnal_update] ON [dbo].[aGL_Jurnal]
FOR UPDATE
AS
if (select flgpost from inserted) = 1
begin
RAISERROR (‘Cannot update this journal.’, 16, 1)
ROLLBACK TRAN
end
rianto utomo isaac sahala utomo
CREATE TRIGGER [jurnal_update] ON [dbo].[aGL_Jurnal]
FOR UPDATE
AS
if (select flgpost from inserted) = 1
begin
RAISERROR (‘Cannot update this journal.’, 16, 1)
ROLLBACK TRAN
end
Written by isaaconi
Februari 7, 2011 pada 3:39 pm
search site archives
Tinggalkan komentar