Guest User

Untitled

a guest
Jan 23rd, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. INSERT INTO R01 (NUMERO,EXPORTADOR, IMPORTADOR, DATAANTECIPADO, STATUS)
  2. VALUES
  3. (64, 'CCB TESTE LTDA.', 'CCB TESTE LTDA.', (select cast('Now' as date) from rdb$database), 'A')
  4. WHERE NOT EXISTS ( SELECT * FROM R01 WHERE NUMERO=64 ,SERIE='CTE' );
  5.  
  6. CREATE OR ALTER PROCEDURE SP_STACKOVERFLOW (
  7. p_numero integer,
  8. p_serie varchar(3),
  9. p_exportador varchar(255),
  10. p_importador varchar(255))
  11. as
  12. declare variable existe integer;
  13. declare variable dataatual integer;
  14. begin
  15.  
  16. select
  17. count(r01.<id da sua tabela>)
  18. from
  19. R01
  20. where
  21. numero = :P_NUMERO and
  22. serie = :p_serie
  23. into
  24. :existe;
  25.  
  26. if (existe = 0) then
  27. begin
  28.  
  29. dataatual = current_date;
  30.  
  31. INSERT INTO R01 (NUMERO, EXPORTADOR, IMPORTADOR, DATAANTECIPADO, STATUS)
  32. VALUES
  33. (:p_numero, :p_exportador, :p_importador, :dataatual, 'A');
  34. end
  35.  
  36. end
  37.  
  38. execute procedure SP_STACKOVERFLOW(64, 'CTE', 'CCB TESTE LTDA.', 'CCB TESTE LTDA.');
  39.  
  40. INSERT INTO R01 (NUMERO,EXPORTADOR, IMPORTADOR, DATAANTECIPADO, STATUS)
  41. select 64, 'CCB TESTE LTDA.', 'CCB TESTE LTDA.',
  42. (select cast('Now' as date) from rdb$database), 'A')
  43. from dummy
  44. WHERE NOT EXISTS ( SELECT 1 FROM R01 WHERE NUMERO=64 ,SERIE='CTE' );
Add Comment
Please, Sign In to add comment