home *** CD-ROM | disk | FTP | other *** search
/ Chip 2000 May / Chip_2000-05_cd1.bin / tema / SW602 / Winbase / EShop_demo / TEST_DATUM.TRG < prev    next >
Text File  |  2000-03-16  |  248b  |  9 lines

  1. {$$3206079764 .                              }TRIGGER `test_datum` AFTER UPDATE OF `DATUM_D`
  2. ON `Obj_header`
  3. REFERENCING OLD AS `oldrec` NEW AS `newrec`
  4. FOR EACH ROW
  5. IF (newrec.datum_d<=today+1)  THEN
  6.    SET newrec.datum_d=today;
  7.  END IF;
  8.  
  9.