Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. public function insertCondicional($suma,$prima,$fetra,$ustra,$actra,$mqtra){
  2. global $libl;
  3.  
  4. $sql=$this->connect->prepare("MERGE INTO ".$libl.".CTRALTAB A
  5. USING ".$libl.".CTRALTEMP B
  6. ON ( A.ACTIAR=B.ACTIAR and A.ACARGU = B.ACARGU AND A.ACFUNC<>B.ACFUNC )
  7. WHEN MATCHED THEN UPDATE SET A.ACFUNC=B.ACFUNC
  8.  
  9. WHEN NOT MATCHED THEN INSERT
  10. VALUES( 1242, RIGHT ('000000000' || DIGITS($suma), 15),
  11. RIGHT ('0000000000000000000000000000000000'||000000000000000||DIGITS($prima) , 50)
  12. , :fetra
  13. , :ustra
  14. , :actra
  15. , :mqtra )");
  16.  
  17. $sql->bindparam(":fetra", $fetra);
  18. $sql->bindparam(":ustra", $ustra);
  19. $sql->bindparam(":actra", $actra);
  20. $sql->bindparam(":mqtra", $mqtra);
  21.  
  22. $sql->execute();
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement