SHARE
TWEET

Untitled

a guest Jul 21st, 2019 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TRIGGER after_table_update
  2. After_hsi.keyrecorddata202_UPDATE
  3. FOR EACH ROW
  4. BEGIN
  5.     UPDATE hsi.keyrecorddata202
  6.     SET kg563 = hsi.keyrecorddata202.kg275 * ['Price_List$'].Unitprice
  7.     FROM hsi.keyrecorddata202
  8.     INNER JOIN ['Price_List$'] ON hsi.keyrecorddata202.kg487 = ['Price_List$'].NO#
  9.     WHERE kg568 = 'FOOD'
  10. END;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top