how to Copy value data with trigger in another table?

Amrul NigthBlue

9y1k

hi, i need help how to copy value data with another table if Tbl_Transaksi "STATUS= IN" copy in TBL_MASUK and if "STATUS=OUT" copy in TBL_KELUAR. i want to make with trigger.

Thank You

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amrul NigthBlue9y ago
Stil confuse , im trying make in mysql with this code working
CREATE TRIGGER `tambah` AFTER INSERT ON `transaksi`
FOR EACH ROW IF NEW.keterangan = 'masuk'
THEN
INSERT INTO masuk (idtransaksi, nama, keterangan, jumlah) VALUES (NEW.idtransaksi, NEW.nama, NEW.keterangan, NEW.jumlah);
ELSEIF NEW.keterangan = 'keluar'
THEN
INSERT INTO keluar (idtransaksi, nama, keterangan, jumlah) VALUES (NEW.idtransaksi, NEW.nama, NEW.keterangan, NEW.jumlah);
END IF
Gokhul Varman9y ago
If you refer the link you can get a good understanding abut it:https://www.sqlservercentral.com/Forums/Topic1253573-1292-1.aspx
Amrul NigthBlue9y ago
It does not working,
im trying code like this but, it same not working
CREATE TRIGGER LOG_Transaksi
ON Transaksi
AFTER INSERT
AS
   BEGIN
    DECLARE @status varchar(50)
    SELECT @status = (SELECT Status FROM Inserted)
    IF @status = 'IN'
        SELECT Kode_Barang, Kode_Transaksi, Nama_Barang, Jumlah, Tanggal, Keterangan, Mengetahui, Diketahui FROM Tbl_Masuk
    ELSE IF @status = 'OUT'
        SELECT Kode_Barang, Kode_Transaksi, Nama_Barang, Jumlah, Tanggal, Keterangan, Mengetahui, Diketahui FROM Tbl_Keluar

        END
Manas Mohapatra9y ago
You can try like this:
CREATE TRIGGER trig_UpdateValues
ON Tbl_Transaksi
AFTER INSERT
AS
    DECLARE @var int
    SELECT @var = (SELECT Status FROM Inserted)
    CASE @var
    WHEN 'IN' THEN
        THEN SELECT ColumnName FROM Tbl_Masuk
    WHEN 'OUT' THEN
        THEN SELECT ColumnName FROM Tbl_Keluar
    ELSE
        -- do something else
    END