Advertisement
KateBarylo

Untitled

Mar 27th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.69 KB | None | 0 0
  1.     INTO :IdFio, :KodDiv, :KodDisc, :KodSGroup
  2.     do    
  3.   BEGIN
  4.  
  5.     IF (OldIdFio <> -1 AND ((IdFio<>OldIdFio) OR (KodDiv <>OldKodDiv) OR (KodDisc <>OldKodDisc) OR (Z(KodSGroup) <> Z(OldKodSGroup)))) THEN BEGIN
  6.  
  7.       ID_FIO = OldIdFio;
  8.       KOD_DIV  = OldKodDiv;
  9.       KOD_DISC = OldKodDisc;
  10.       KOD_SGRP = OldKodSGroup;
  11.       suspend;
  12.       HOUR_SUM = 0;
  13.     END
  14.     OldIdFio = IdFio;
  15.     OldKodDiv = KodDiv;
  16.     OldKodDisc = KodDisc;
  17.     OldKodSGroup = KodSGroup;
  18.     HOUR_SUM = HOUR_SUM + 2;
  19.   END
  20.  
  21.   ID_FIO = IdFio;
  22.   KOD_DIV  = KodDiv;
  23.   KOD_DISC = KodDisc;
  24.   KOD_SGRP = KodSGroup;
  25.   suspend;                                                                          
  26. END^
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement