Advertisement
Guest User

Untitled

a guest
Jul 21st, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement