Hi SQL Gurus,
I have an order processing application where the Order Item must be
REJECTED If the stock is NOT Available.
I have a Stock Table that interactively updated during data entry.
CREATE TABLE MSSTK -- Table for Stock Availibility
(PRODCode CHAR(5) NOT NULL Primary Key,
I am using CASCADE DELETE in the Foreign Key from Order Detail to Order
Header. Below is the TRIGGER For ORDER DETAIL.
The question is : Is this the correct way making sure if the Order Item
is only INSERTED if the Stock Available ??
ALTER TRIGGER TD_T02QUOD
ON T02QUOD ...