I have two tables below named stock and sent in a trouble to make trigger. What I need, If any user update or insert data in stock table,the "sent" column should change to '1' and also insert that updated row to stocksent table. We have to sonsider the duplicate value should not be added to stocksent table..
After senting Stocksent data to Another Location I want to delete the records in stocksent table and to change the sent column of the stock table to '0' again..
Please any one can help me....?
create table STOCK,stocksent
(itemcod char(8)primary key,
refcode char(10),
grpid char(5),
grpdrs char(6),
brandname char(15),
descript char(30),
pack char(15),
stock numeric(5),
sent int(1)default'0',
)
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).