Advertisement
Guest User

Untitled

a guest
May 22nd, 2017
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. declare
  2. TYPE cur IS REF CURSOR;
  3. cur_klient cur;
  4. Num NUMBER;
  5. begin
  6.  
  7. OPEN cur_klient FOR
  8. SELECT KlientID
  9. FROM klient
  10. WHERE KlientID = :DOGOVOR.KlientID;
  11.  
  12. fetch cur_klient into Num;
  13. if cur_klient%ROWCOUNT < 1 THEN
  14. Set_Alert_Property('ALERT_DOG',TITLE,'Ошибка ввода данных.');
  15. Set_Alert_Property('ALERT_DOG',ALERT_MESSAGE_TEXT,'Клиента с таким кодом не существует в БД.');
  16. Num := SHOW_ALERT('ALERT_DOG');
  17. Go_Item('DOGOVOR.KLIENTID');
  18. CLEAR_ITEM;
  19.  
  20. :DOGOVOR.KlientID := '';
  21. end if;
  22.  
  23. CLOSE cur_klient;
  24. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement